Question

Computer Assignment 3: Spreadsheet Models Due Date: Nov. 19, 2018 (Blackboard) Instructor Dr. K. Lim Assume that the annual fixed cost for manufacturing the calculator is $340,000 and the total variable cost is $4.8 for each unit produced. The manufacturer has a bid form an outside firm 9 to produce the calculator for $6.5 per unit. QI" The total cost for producing 12,000 units of the calculator (TMC) is 02. The total cost for outsourcing (purchasing) 12,000 units of the calculator (TPC) Q3. The savings due to outsourcing is Q4. The break-even point is about Q5. The average cost/unit for the production of a particular component at a manufacturing plant varies with the number of units produced in each batch. The data are given below: Number of units produced 0-49 50-100 Cost/unit S37.72 $25.02 Suppose the selling price of each unit is $30. Build a model to calculate the profit of the manufacturing industry if the demand is 40. The Profit is

Answer 1

ven, Annuo, fixed 데ste $849000 outsouacing goods st paqwvnt : 후 6.5 3110,000 t 4-2 (t2000) 347, 600 소 340000 P- 4-0 34000 Co. 午31.72 For clemand ·There is als