Please help calculate the first four requirements I will post below. All data will be attached.

E Home X E Course Project: MGMT 312 Mana X Search Results | Course Hero + X C erau.instructure.com/courses/117543/pages/course-project GR . .. Apps E 1.2 Readings and R... Library Genesis do... New Tab E G weather briefing for.. Free Text Summ.. Conclusion Generat.. APA Citation Forma... . Paraphrasing Tool -. rcopic EagleVision Zoom DIRECT MATERIALS Hunt Library Cost Behavior Units per Case Cost per Unit Direct Materials Cost per Case Bookstore Cream base Variable 100 oz $0.02 $2.00 Account eUnion Natural oils Variable 30 oz $0.30 $9.00 Bottle (8 oz) Variable 12 bottles $0.50 $6.00 Dashboa Total $17.00 rd DIRECT LABOR Courses Department Cost Behavior Time per Case Labor Rate per Hour Direct Labor Cost per Case Mixing Variable 20 minutes $18.00 $6.00 Groups Filling Variable 5 minutes $14.40 $1.20 Total 25 minutes $7.20 Calendar FACTORY OVERHEAD Cost Behavior Total Cost Inbox Utilities Mixed $600 Facility lease Fixed $14,000 Studio Equipment depreciation Fixed $4300 ? Supplies Fixed $660 Help Total $19,560 https://erau.instructure.com/courses/117543/pages/course-project#kl_panel_1_content Type here to search W X 10:18 AM O P 9/1/2020AutoSave O Off) 1 5 - Cv B v = MGMT312_Course Project_Template (1) - Protected View - Excel Search will walsh ww X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X C7 X V fx Contribution Margin is calculated correctly. Math process is present. A B F G H K L M N P 1 Course Project Grading Rubric - Students Points Criteria Excellent Good Fair Poor Unacceptable Available Fixed and variable portion Fixed and variable portion Fixed and variable portion Fixed and variable portion of |The submission does of the utility cost using the of the utility cost using the of the utility cost using the the utility cost using the high- | not meet this Step 1- High-Low high-low method have the | high-low method mostly ow method have various equirement. Math Milestone 1 high-low method have Method amounts; formula is used have accurate amounts some errors; formula has errors; formula has various | process is not present. correctly, math process is formula is mostly used some errors, math process errors, math process is present. correctly, math process is is present. present Step 1 Grading Scale 8-7 6-5 4-3 2-1 0 8 Contribution Margin is Contribution Margin is Contribution Margin has Contribution Margin has The submission does Step 2 - Contribution |calculated correctly. Math | mostly calculated correctly. some errors. Math process various errors. Math process not meet this Milestone 1 Margin process is present. Math process is present is present is present. requirement. Math process is not present. Step 2 Grading Scale 8-7 6-5 4-3 2-1 0 8 Fixed costs are calculated | Fixed costs are mostly Fixed costs have some Fixed costs The submission does correctly. Math process is calculated correctly. Math errors. Math process is errors. Math process is not meet this Milestone 1 Steps 3 - Fixed Costs |present process is present present present requirement. Math process is not present. 9 10 Step 3 Grading Scale 3-7 6-5 4-3 2-1 0 B Break-even analysis is Break-even analysis is Break-even analysis is has Break-even analysis is has The submission does | applied correctly leading mostly applied correctly some errors leading to various errors leading to an not meet this Milestone 1 Steps 4 - Break-even Analysis to an accurate result. Math | leading to a mostly marginaly accurate result. incorrect result. Math requirement. Math process is present accurate result. Math Math process is present. process is present. process is not present. process is present. Step 4 Grading Scale 9-8 7-E 5-4 3-2 1-0 9 Milestone 1 Total 33 The production budget is The production budget is The production budget is The production budget is The submission does prepared accurately and in | prepared accurately and prepared with several prepared with significant not meet this Milestone 2 Step 5 - Production an appropriate format. mostly in an appropriate errors, but is prepared in an | errors, using an inappropriate requirement. Math Budget Math process is present. ormat, but may have some appropriate format. Math format. Math process is process is not present. minor errors. Math process process is present. present. 14 is present. 15 Step 5 Grading Scale 6-5 4-3 6 . .. 9 - Budgeted Income Statement 10 - Direct Materials Variance 11 - Direct Labor Variance 12 - Factory Overhead Variance Grading Rubric + Ready + 70% Type here to search O Fi W P T e 10:18 AM 9/1/2020 21AutoSave O Off) MGMT312_Course Project _Template (1) - Protected View - Excel Search will walsh ww X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 1PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H25 X A B C D E F G H J K L M N O P 1 REQUIREMENT #1: Determine the fixed and variable portion of the utility cost using the 2 High-Low Method Variable Difference Cost per Difference in Total Cost in Unit Productio = Variable Units Total Cost Cost per of Unit Produc Fixed tion Costs 8 High Point 9 Low Point 11 11 X + X + 10 11 12 13 14 15 16 17 18 19 20 . . . Transactions 1 - High-Low Method 2 - Contribution Margin 3 - Fixed Costs 4 - Break-even Analysis 5 - Production Budget 6 - Direct Materials Purchases + + 100% Ready 10:18 AM Type here to search O W P e 9/1/2020File Hume Insert Draw Page Layout Furmulas Data Review View Help 3 Share T Comments PRDTECFED VIEW Be carefulM5 tram the Internet can contain VINSS. Unlm you need to edit, It's safer to stay In Protected View. Enable Editing X F20 ' E A f: v A A l B l C l D l E l F I G H | l | J l | O | P | A 1_ REQUIREMENT #2: Determine the contrinution rnarain per case. um Contribution Margin Selling Price Less variable costs per case: Direct materials Direct labor 1!) Utilities (see High-Law Method) E Selling expenses 3 Total variable costs per case '13 E Contribution mar in er case 3 16 E E 3 a |:. a g 23 E 1* HigtrLo l P Type here to search an E a A u 5 , Production Budget 'I+ 100% MGMT312_Course Project_Template (1) - Protected View - Excel Search will walsh ww X AutoSave O Off) Comments File Home Insert Draw Page Layout Formulas Data Review View Help Share 1PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H32 X V fx A B C D E F G H J K L M N O P 1 REQUIREMENT #3: Determine the fixed costs per month, including the utility fixed cost from question (1). W N Total Fixed Costs Utilities [see High-Low Method] 6 Facility lease Equipment depreciation 8 Supplies 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Transactions 1 - High-Low Method 2 - Contribution Margin 3 - Fixed Costs 5 - Production Budget 6 - Direct Materials Purchases + . .. 4 - Break-even Analysis + 100% Ready 10:18 AM Type here to search O W P e 9/1/2020AutoSave O Off) MGMT312_Course Project _Template (1) - Protected View - Excel Search will walsh ww X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F6 X A B C D E F G H J K L M N 1 Requirement #4: Determine the break-even num ber of cases per month. W N Break-even Analysis Unit Break-even Sales (units) Fixed Costs Contribution n Margin 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Transactions 1 - High-Low Method 2 - Contribution Margin 3 - Fixed Costs 4 - Break-even Analysis 5 - Production Budget 6 - Direct Materials Purchases 7 + . .. + 100% Ready 10:18 AM Type here to search O W P T e 9/1/2020