please help with the cost of goods section and selling & admin expense section. I also do not understand what he means when it says cash payments for raw materials, labor - current month and overhead. I provide pictures.
abc X, X A. A = = == M T Normal 1 No Spac... Heading Hea Font Paragraph ecause your Office product is inactive. To use for free, sign in and use the Web version. Styles Use free at Office.com Activate WBC sales staff have prepared a schedule of the budgeted sales for the months of January through December 2019. Expected unit sales for the months of 2019 are listed below: January February March April May June July August September October November December TOTAL 1000 3000 3000 2250 10000 7750 1000 1500 1000 2000 1000 2500 36,000 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Styles ersion. Activate Use free at Office.com WBC sells the Winds to Home Depot and its other a ta price of H10 each. WBC sells all the blinds on account and expects to collect 80% of the cash in the mouth of the sale and 40% in the month after the sale Production and Material Budget Laformation Finished Goods Window Blinds Company (WBC) mamafactures window blinds from wood. Each blind uses 3 feet of high quality teak hartwood, which costs WBC 33 per foot WBC likes to end the finished goods inventory equal to 30% of the planned sales for the next month Raw Materials In addition to the finished poods inventory, WBC also has an inventory of Teakwood in a climate controlled warehouse WBC like to b e in its warehouse a beginning inventory equal to 40% of the teak wood it will need for the month's production WBC pays for the materialit purchases in the month of purchase Labor Budget Information WBC pays its worcers 511 per hour and each blind takes 1 hour of laber to complete. All wages are paid in the month incurred Manufacturing Overhead Information Total manufacturing overhead is estimated to be 594,500. Manufacturing Overhead is applied equally to each product produced Overband is paid in the mouth incurred Selling and Administrative Costs Selling and admistrative penses are a combination of sted and variable coit. Fixed selling and Administrative costs are estimated at 38.000 per month and variable selling and d e coltare 3500 per unit sold. Selling and d istrice costs are paid in the month incred Cash Management WECatati the math of April with $2.000 in the bank. Ma e would be manten of S10.000 in the bank BC jest opam e credit with the bank that they c n last day of the ch artis pead teed of the oth of the lecf credit cat be paid tack it Interest charged alle toetada balance bomoured pboard Font Alignment Number I A B April May June | Total 4,575 9,325 5,725 19,625 3 27,975 17,175 Scheduled Production 6 Raw Materials X's Amount of Raw Material per Completed Unit (in Fee Budget Total raw materials needed for production Plus: Ending Raw Materials Inventory Less: Beginning Raw Materials Inventory Materials for Purchase X's Acquisition Price per foot - Raw Materials 13,725 11,190 6,870 1,380 5,490 6,870 58,875 19,440 23,550 54,765 3.00 11,190 23,655 3,00 19,425 3.00 11,685 3.00 $ S $ Cost of Materials Needed to Purchase $ 58,275.00 $ 70,965.00 $ 35,055.00 $ 164,295.00 Cash Payments for Raw Materials April May June Total 4,575 9,325 5,725 19,625 40 Direct Labor Production (Completed Units) Direct Labor Per Unit Total Direct Labor Hours required X's Average Hourly Labor Rate 5725 4575 11.00 9325 11.00 19625 . 11.00 $ $ 11.00 S Total Direct Labor Cost $ 50,325.00 $ 102,575.00 $ 62,975.00 $ 215,875.00 Cash Payments Labor - Current Month May Production (Competed Units) Sheet1 Sheet2 Sheet3 April 4,575 9 ,325 June 5,725 Total 19,625 Ready to AutoS o n A Home 2 Insert Search Developer Help Spring 2020 Budget Worksheet Master (1) Excel Draw Page Layout Formulas Data Review View - 11 1 - AA EE . Wrap Test . .A = = = Merge & Center Calibri ber Peste BIU. Conditional Formata Formatting Table Cash Payments Labor. Current Month April May 9,325 June 5,725 Total 19.625 Production Competed Units) 10 Manufacturing Is Overhead rate $1 Overhead Total Overhead 22030 44,903 27,568 94,500 Cash Payments Overhead April May June Total Direct Materials per unit Cost of Goods Direct Labor per unit s tedes units) Total Material and Labor Manufacturing Overhead Cost of Goods Sold April June Budyt Sales in Units 66 Selling & Admin 's Variable Selling and Admin Expense per unit Fixed Selling and Admin Expenses Total Selling and Admin Expenses Window Blinds Company Pro Forma Income Statement Sheet1 Sheet2 Sheet3