Question

Questions are below. Only answer problems #5 - #9.

Quivers Inc. began operations on January 1 of the current year. The company produces eight-ounce bottles of jet wax called Ophelia Shine. The wax is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case. The January direct materials, direct labor, and factory overhead costs are as follows: DIRECT MATERIALS Cost Units Cost Direct Materials Behavior per Case per Unit Cost per Case Creambase Variable 100 oz. 50.02 $ 200 Natural oils Variable 30 oz. 0.30 9.00 Bottle (8-02) Variable 12 bottles 0.50 6.00 $17.00 Department Mixing Filling Соя Behavior Variable Variable DIRECT LABOR Time per Case 20 min 5 25 min Labor Rate per Hour $18.00 14.40 Direct Labor Cost per Case 56.00 120 5720 FACTORY OVERHEAD Cost Behavior Total Cost Utilities Mixed $ 600 Facility lease Fixed 14.000 Equipment depreciation Fixed 4300 Supplies Fixed 660 519,560 Part A. Break-even Analysis The management of Quivers Inc. wants to determine the number of cases required to break even per month. The utilities cost, which is part of factory overhead, is a mixed cost. The following information was gathered from the first six months of operation regarding this cost: Month January February March April May June Case Production 500 800 1,200 1.100 950 1,025 Utility Total Cost 600.00 s 660.00 s 740.00 s 720.00 S 690.00 $ 705.00 Instructions 1. Determine the fixed and variable portion of the utility cost using the high-low method. 2. Determine the contrinution margin per case. 3. Determine the fixed costs per month, including the utility fixed cost from question (1). 4. Determine the break-even number of cases per month

I have already answered problems #1-4, my data is below.

Problems #5-#9 are listed in order below.

Please help, Ive submitted this question 4x and recieved no help. I will rate! Thank you

Answer 1

5# Production Budget un For The Mooth ot Dugust 31 cases Expected cars to be sad ie Denbood- 150000 175 cas plus olesned oding Covestory Total Joits requirred (1500+ior) - 1675.ca Less: Estimated being in the lushny, Decoduceel = 300 can Total units to be produced = 1675 – 300 = 13 75 cases

22 QL0050 37/24 Bacuml 57/01 Direct Materials Purchase Budget For the mooth of Augest 31 Cream Bau Natural Bottle Total wits required for Produchis) 1395 X 10002 1395 2002 13975X12 137sto oz 4250 02 16 500 1000 02 360o2 2406 plus deired Exding hvestory lotal isits required 138500 41610 16740 ess: Estimated beginning lovartey 250 2010 Goo lotal materials to be Perchased 13825041320 16140 cost (unit x price $2865 $12396 $8080 lotal Direct materials to be purchared = $23231

29 Sunday Dom: 16 molso 40/29 jota 56/32 Labour units x Production Time 1 Hour -Total Mixing 1375 x 20 160 lsplus 458-33 1325 x Elling x 5160 2114.58 Total 572.91 Utilities Igual fontordonats 14 Requirement #8 Exedy Variable Totel $ 500 275 2775 olsos laid to Factopnity lean $ 14000 loud - 1 (1000 Equipment Depreciation $ 4300 Download Supplier & 660 с. boer Total factory Overhead cost 19735 - 4300 2660 word

28 Saturday #7 Raw materials Total units x Volume Cream Bane 138250 0.02 $ 2205 sooolaardi alhora rol lorop Natural oils 41320 x 0.30 & 12896 Bottles 16 140 x 0.50 = $ 8000 Direct Labour cost Budget Mixing Gllog Hos required for production to of ballo Ophelia Was prodde innig 20 min 5 min Os For 13 75 came 458.33 lirs & 114 586 on Total direct labour cost $8249.95 $ 1649.99 Total diveet labour cost b $ 9900

29 Sunday Dom: 16 molso 40/29 jota 56/32 Labour units x Production Time 1 Hour -Total Mixing 1375 x 20 160 lsplus 458-33 1325 x Elling x 5160 2114.58 Total 572.91 Utilities Igual fontordonats 14 Requirement #8 Exedy Variable Totel $ 500 275 2775 olsos laid to Factopnity lean $ 14000 loud - 1 (1000 Equipment Depreciation $ 4300 Download Supplier & 660 с. boer Total factory Overhead cost 19735 - 4300 2660 word