Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 401 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Accounting Posted 22 Jul 2017 My Price 11.00

VARYING SALES MIX

USING A COMPUTER SPREADSHEET TO SOLVE MULTIPLEPRODUCT BREAK-EVEN, VARYING SALES MIX

The following projected income statement for More-Power Company is repeated for your convenience. Recall that the projection is based on sales of 75,000 regular sanders and 30,000 mini-sanders.

 

Regular

 

 

 

Sander

Mini-Sander

Total

Sales

$3,000,000

$1,800,000

$4,800,000

Less: Variable expenses

1,800,000

900,000

2,700,000

Contribution margin

$1,200,000

$ 900,000

$2,100,000

Less: Direct fixed expenses Product margin

250,000

450,000

700,000

$ 950,000

$ 450,000

$1,400,000

Less: Common fixed expenses

 

 

600,000

Operating income

 

 

$ 800,000

Required:

1. Set up the given income statement on a spreadsheet (e.g., Excelâ„¢). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d).

 

Regular Sander

Mini-Sander

a.

75,000

37,500

b.

60,000

60,000

c.

30,000

90,000

d.

30,000

60,000

2. Calculate the break-even units for each product for each of the preceding sales mixes.

Answers

Maurice Tutor
(5)
Status NEW Posted 22 Jul 2017 09:07 PM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------sol-----------uti-----------on.-----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- ca-----------tch-----------

Not Rated(0)