Creating a chart using a spreadsheet Chart Wizard involves four steps. Which is the first step?
2 answers:
You might be interested in
Complete Question is as under:
JJ Manufacturing builds and sells switch harnesses for glove boxes. The sales price and variable cost for each follow:
PRODUCTS Selling Price Per Unit Variable Cost Per Unit
TRUNK SWITCH $60 $28
GAS DOOR SWITCH $75 $33
GLOVE BOX LIGHT $40 $22
Their sales mix is reflected in the ratio 4:4:1. If annual fixed costs shared by the three products are 18,840.
Requirement 1: How many units of each product will need to be sold in order for JJ to break even?
Requirement 2: Use the information from the previous exercises involving JJ Manufacturing to determine their break-even point in sales dollars.
Kindly Find the Solution in the attachment.
Answer:
B) plan 1 : worker earning y = x - 0.14 , unit labor =
plan 2 : worker earning y = 0.5x + 0.5, unit labor = (0.5x + 0.5) / x
C) At 128%
D ) plan D IS PREFERABLE
Explanation:
In the first case Benefits are split : 30% to worker , 70% to company ( up to 120% ) performance
In the second case benefits 50% go to the worker and 50% go the company
B) The equations for worker earnings and normalized unit labor costs for each scheme
Plan 1 :
y ( percentage earning of worker ) = 1
unit labor cost = Y / 1
y = 0 - 30
unit labor = 0.3 / x
y = x - 0.14 therefore unit labor =
plan 2 :
y ( percentage earning of worker ) = 1, y = 0.5x + 0.5
unit labor cost : Y / 1 = (0.5x + 0.5) / x
C ) The point at which the two plans break even
0.5x + 0.5 = x - 0.14
0.5 + 0.14 = x - 0.5x
0.64 = x(1 - 0.5 )
x = 0.64 / 0.5 = 1.28 = 128%
D) The company would prefer plan 1