Excel Model 1 - Quiz B Started: Feb 27 at 8:04pm Quiz Instructions Be sure to prepare your excel model prior to taking this quiz. Be sure you have completed Quiz A with a perfect score before taking this quiz. Have your excel model open on your computer before starting this quiz. Each question will ask you to modify your model's input data and give a newly calculated answer to a question. Any input numbers that are not specifically changed should be the original scenario numbers. Each individual question is stand-alone. In other words, after each question update your input section to the original data from the base scenario. Then, change the specific input numbers that are given in the question. If you don't do well on your first attempt, go back and try to fix your model. The number one mistake is not using references to the input cells in your formulas. You should not hard code numbers into your formulas, instead, you should reference cells in the input section. Note: this is a timed quiz. You may check the remaining time you have at any point while taking the quiz by pressing the keyboard combination SHIFT, ALT, and T... Again: SHIFT, ALT, and T..

Question 1 2 pts If unit sales price is $45, and total units produced and sold is 217676 what are total sales? (all other inputs should be from the base scenario) Enter your answer rounded to the nearest whole dollar.

Question 2 2 pts If variable manufacturing expense per unit are $13.70 each and the number of units produced and sold are 245123, what are total variable costs? (All other data should be from the base scenario). Enter your answer rounded to the nearest whole dollar

Question 3 2 pts If : Selling price is $58.89 Fixed Manufacturing Overhead Expense is $2264504 Units produced and sold is 208513 What is operating income? All other data is from the base scenario. Enter your answer rounded to the nearest whole dollar.

Question 4 3 pts If: Selling price is $49.02 Variable Manufacturing expense per unit is $13.63 Variable Marketing expense per unit is $7.03 Variable Administrative expense per unit is $2.95 And Units produced and sold are 217338 What is total contribution margin? All other data is from the base scenario. Enter your answer rounded to the nearest whole dollar.

Question 5 3 pts If: Selling Price per unit is $47.09 Variable Manufacturing expense per unit is $10.75 Variable Marketing expense per unit is $5.92 Variable Administrative expense per unit is $2.47 What is contribution margin per unit? All other data is from the base scenario. Enter your answer rounded to two decimal places.

Question 6 2 pts If Unit Selling Price is $48 Fixed Manufacturing Overhead Expense is $2472536 Fixed operating expenses $214063 What is BEP in Units? All other data is from the base scenario. Round your answer up to the nearest whole unit.

Question 7 2 pts IF Variable Manufacturing expense per unit is $15 and Sales Price is $51 What is Contribution Margin Ratio? All other data is from the base scenario. Input your number to one decimal place, for example .1012 would be input as 10.1. Do not use a percentage sign

Question 8 3 pts If: SP is $46.89 Variable Marketing Expense per unit is $5.53 Variable Administrative Expense per unit is $2.82 What is Variable cost as a percentage of selling price? All data is from the base scenario. Input your number to one decimal place, for example .1012 would be input as 10.1. Do not use a percentage sign.

Question 9 3 pts If : Fixed Manufacturing Overhead Expenses are $2459400 Fixed Operating Expenses are $234895 What is Operating Leverage? Input your number to TWO decimal places All other data is from the base scenario.

Question 10 3 pts IF: Unit Selling Price is $49.60 Variable Manufacturing expense per unit is $15.60 Variable Marketing expense per unit is $5.02 Variable Administrative Expense per unit $2.84 Fixed Manufacturing Overhead is $2269892 Fixed operating expenses are $234020 Units sold and produced is 238486 What is operating income? Enter your answer rounded to the nearest whole dollar.

Statementshowing Computations aticulars Sales 230,000 65 Variable Costs variable manufacturing expnse Variable marketing expense variable administrative expenses Total Variable costs Contribution Margin Fixed Costs Fixed manufacturing overhead Fixed operating expenses Fixed Costs BEP in Units FC/Cont per unit 2650,000 36 BEP in 73,611.11 65 CM Ratio: 36/65 VC Ratio 29/65 Operating Leverage Contribution EBIT 8280,000/5630,000 Amount Per Unit 14,950,000.00 65.00 18.00 4,140,000.00 8.00 1,840,000.00 690,000.00 3.00 6,67o, ooo oo 29.00 8,280,000 oo 36.00 2,375,000.00 275.000.00 2,650,000.00 5,630,000.00 73,611.11 4,784,722.22 554 44.6% 147