Calibrated manufacturing makes an electronic component that is in great demand.  The component sells for $20 each.  Calibrated’s current capacity is 10,000 units per week.  For the last few months, however, the company has been receiving new orders at a rate of 14,000 units per week, and now has a substantial backlog.  The company expects this order rate to continue, if it maintains price.  Calibrated’s current operating data follows:Sales Revenue $200,000 Variable Costs $100,000 Fixed Costs $80,000 Pretax Profit $20,000 For each incremental addition of 500 units of output weekly, Calibrated would need to purchase new equipment that would add $1,500 to weekly fixed costs.  No other fixed costs would become incremental for this price change.  Labor costs currently account for half of all variable costs.  Additional hires, however, are expected to be more costly than the average of current employees because of their lower productivity.  Although new hires are paid (wages + fringe benefits) only 80% of the current average, they can produce only two-thirds as much output per hour.  Consequently, labor costs for additional output with new hires is 20% higher than the current average.Calibrated is debating whether to keep its current price and expand to meet the demand or to raise its price to reduce demand somewhat before deciding whether or not to expand.How much would Calibrated’s weekly profits increase if it expanded to meet the entire amount of its current excess demand? Prepare an analysis of a 10% price increase Calculate the break-even sales quantity (percent and units) Calculate the new $ contribution margin per unit What risks might be to Calibrated of increasing price to maximize profit? What risks might there be to Calibrated of expanding output rather than reducing demand through a price increase

Solve Problem and Applications: ch 13- prob 7 [Klein Industries manufactures three types of portable air compressors] in page 451 at the end of chapter 13 in your textbook, USA 5th edition. The data is given as part of the question. There is no external data set provided. Use what is given by the problem.

Solution Tip: You must use Solver tool in Excel. Set your constraints right, and fill in the solver dialogue box properly. Be sure to review links provided in the last lesson, or in one of the announcements in the first week of class. Here is a You Tube link you could view: http:// additional slides to explain basics and a basic example is attached. The example and slides are for demonstration and illustration purpose only to help practice how to use solver tool.