# please solve the following problem using excel commands

please solve the following problem using excel commands

Please solve the following problem using the excel spreadsheet command. Also see the attached documents for instructions and example of typical problem solved.

SkiCo, Inc. manufacturers ski boots. The Company’s projected income for coming year, based on sales of 160,000 units, is as follows:

sales…………………………………………………….$16,000,000

Operating expenses:

Variables expenses…………..$4,000,000

Fixed expenses………………..$6,000,000

Total expenses………………………………………$10,000,000

Net income……………………………………………..$6,000,000

Required: in completing the following requirements, ignore income taxes.

question 1: Prepare a CVP graph for SkiCo, Inc., for the coming year

question 2: Calculate the firm,s break even point for the year in sales dollars

Question 3: what is the company’s margin of safety for the year?Step by step guidelines.pdf example of typical problem solved.pdf