Please let me know if you need ang additonal information. Each excel photo has the requirement # listed on the too left corner, which correlates to the questions listed on the first photo part B. thank you!

Scenario Quivers Inc began operations on January 1 of the current year. The company produces eight-ounce bottles of je wax caled 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 maledols, direct labor and factory overhead costs are as follows: Create Nu Bande DRECT MATERIALS Cent Un their Vw 106 be O. tes pu $0.00 0.30 Dhe Materiale Cautare 3200 900 6.00 $17.00 BRECTLARO The Cow Hehe Laborare Mia M.00 18.00 1640 w FACRYOVERINAD Cert har total en M 600 Facity Red 14000 Equipe de relation Find 300 40 Part B. Budgets During July of the current year, the management of Quivers Inc. asked the controller, Robin, to prepare August manufacturing and income statement budgets. Demand was expected to be 1,500 cases of jet wax at $100 per case for August. Inventory planning Information is provided as follows: Finished Goods Inventory Cases 300 175 Estimated finished goods inventory. August Desired finished goods Inventory, August 31 Materials Inventory Cost $12,000.00 $ 7,000.00 Estimated materials inventory. August 1 Desired materials inventory, August 31 Cream Bose (oz) 250 1,000 Oils (oz) 290 360 Bottels (2) 600 240 There was negligible work in process inventory assumed for either the beginning or end of the month thus, none was assumed. In addition, there was no change in the cost per unit or estimated units per case operating data from January. Instructions 5. Prepare the August production budget. 6. Prepare the August direct materials purchases budget. 7. Prepare the August direct labor cost budget. Round the hours required for production to the nearest hour 8. Prepare the August factory overhead cost budget. 9. Prepare the August budgeted income statement, including selling expenses. D B REQUIREMENT #5: Develop the production budget. 3 4 LONO Quivers Inc. Production Budget For the Month Ended August 31 Cases Expected cases to be sold 1,500 Plus desired ending inventory 175 Total units required 1.675 Less estimated beginning 300 inventory Total units to be 1,375 produced 10 11 12 13 14 15 16 6 18 19 Botries Total Requirement: Develop the direct materials purchases budget Quivers Inc. Direct Materials Purchases Budget For the Month Ended August 31 5 Creom Natural 7 Base lol Os foz) B Units roured for production 137.500 41.250 Plus desired ending inventory 1.000 360 10 Total units required 1,500 41.610 11 Los estimated beginning inventory 250 -200 Total materials to be purchased 130.250 Unitrice $0.02 30:30 Toldrect materials to be purchased 12.765 112.30 14 15 16 ibolti 16.500 240 16.740 100 16.140 30:30 070 Total 13.00 Raw Materials Units X Volume 4,379 30 38 30 1375 12 Oreo Base Nouro Bottes 41.300 1132.000 $23,231 1 Requirement #7: Develop the direct labor cost budget, 4 Qulvers Inc. Direct Labor Cost Budget For the Month Ended August 31 Mbing Filing Houts required for production of: 454 110 Ophela Wax Product Hourly rate $ 18.00 $ 14.40 Total direct labor cost 58.172.00 $1 584.00 5 6 7 8 9 10 11 12 13 Total Mixing Fing Units X 1,375 1.375 Labor Production Time / Hour 20 60 5 80 Total 454 110 hours Hours 59.756.00 15 16 17 18 Cost Cases Total 1 Requirement 68: Develop the factory overhead cost budget 2 3 4 Qulvers Inc. 5 Factory Overhead Coal Budget for the Month Ended August 31 Fixed Variable B 9 Uses 10 Facility Loose $ 14,000 11 Equiment Depreciation 5 4300 12 Supplies $ 13 Total factory overhead cost 14 15 16 Cost 10.00 Total 600 14000 4300 Fleed Cost from Question 31 Variable Utly Cost 660 5 19.640 18 14 20 2 22 Requirement Create the budgeted income totement Units x Price Tolol Sales Quivers Inc. budgeted Income Salement For the Month Ended August 31 Soler Finished goods wentary, August Die moteris Direct materiais inventory. August Dreci moteris purchases from Question Cost of Bremble for Les direct moventory, August Colore monoduction Directioboritom Guifion Factory overom Question Cost of goods morutactured Contoffwed gode voor podendry, Augusta Couto Group Selger Csom de Orect materia for August De termed 1 REQUIREMENT 63: Determine the fixed costs per month, including the unity fixed cost from question (1). Total Fixed Costs G Utilities free how Method Tochty lease Equipment depreciation Supplies 5 500 $ 14000 4.300 40 SILAO 10 11 12 15 16