Master Budget Ch.21 Involved 2

complete the master budget assignment

please help this is due by midnight

A B C D Storm Tools has formed a new business unit to produce battery-powered drills. The business unit was formed by the transfer of selected assets and obligations from the parent company. The unit's initial balance sheet on January 1 contained cash ($500,000), plant and equipment ($2,500,000), notes payable to the parent ($1,000,000), and residual equity ($2,000,000). The business unit is expected to repay the note at $0,000 per month, plus all accrued interest at 1/2% per month. Payments are made on the last day of each month. The unit is scheduled to produce 25,000 drills during January, with an increase of 2,500 units per month for the next three months. Each drill requires $40 of raw materials. Raw materials are purchased on account, and pald in the month following the month of purchase. The plant manager has established a goal to end each month with raw materials on hand, sufficient to meet 25% of the following month's planned production. The unit expects to sell 20,000 drills in January; 25,000 in February, 25,000 in March, and 30,000 per month thereafter. The selling price is $100 per drill. Half of the drills will be sold for cash through a website. The others will be sold to retallers on account, who pay 4005 in the month of purchase, and 6096 in the following month. Uncollectible accounts are not material. Each drill requires 20 minutes of direct labor to assemble. Labor rates are $24 per hour. Variable factory overhead is applied at $9 per direct labor hour. The fixed factory overhead is $25,000 per month; 60% of this amount is related to depreciation of plant and equipment. With the exception of depreciation, all overhead is funded as incurred. Selling general, and administrative costs are funded in cash as incurred, and consist of foxed components (salaries, $100,000; office, $40,000; and advertisine, $75,000 ) and variable components (15\% of sales). Prepare a monthly comprehensive budget plan for Storm's new business unit for January through March. The plan should include the (a) sales and cash collections budget, (b) production budget, (c) direct materials purchases and payments budget, (d) direct labor budget, (e) factory overhead budget, (f) ending finished goods budget (assume total factory overhead is applied to production at the rate of $11.73 per direct labor hour), ( g ) SG\&A budget, and (h) cash budget. Each person must complete a master budget using linking spreadsheets in Google Sheets. This is a free web-based electronic spreadsheet that is similar to Microsoft Excel. The variables, assumptions and requirements are detailed in Chapter 21 , Involved 21.02E. In addition to the required budgets, you must create the budgeted financial statements (Income Statement, Statement of Retained Earnings and Balance Sheet). The purpose of this project is to assess your level of knowledge of the master budget process and your ability to create a simple master budget using an electronic spreadsheet. If you are not an experienced spreadsheet user, this project will take longer because you will need to learn some basic spreadsheet skills. We will spend some class time on the basics, but if you are a beginner, this is a good excuse to invest some time building your electronic spreadsheet skills. This project assesses your knowledge of master budgets and electronic spreadsheets. An experienced spreadsheet user would finish this assignment in 3-4 hours. If you are not an experienced spreadsheet user, the amount of time required could more than double. \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & c & D & E & F & G \\ \hline \multicolumn{7}{|c|}{ Storm Tools, inc. } \\ \hline \multicolumn{7}{|c|}{ Sales Collections Budget } \\ \hline & & January & February & March & April & Quarter 1 \\ \hline Sales & & $1,875,000 & $3,125,000 & $3,125,000 & $3,750,000 & 8,125,000 \\ \hline Sold for Cash & & $937,500 & $1,$62,500 & $1,562,500 & $1,875,000 & $4,062,500 \\ \hline Sold on Credit (Accounts receivable) & & $937,500 & $1,562,500 & $1,562,500 & $1,875,000 & 54,062,500 \\ \hline Cash Collection month of sale & & $375,000 & $625,000 & $625,000 & $750,000 & $1,625,000 \\ \hline Cash Collection subsequent month & & & $562,500 & $937,500 & $937,500 & 1500000 \\ \hline Totalcollection & & $375,000 & $1,187,500 & $1,$62,500 & $1,687,500 & $3,125,000 \\ \hline Accounts receivable & & $562,500 & $937,500 & $937,500 & & $937,500 \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Assumptions } \\ \hline Calcultion & & & & & & \\ \hline \multicolumn{7}{|l|}{ Sales Budget } \\ \hline & & & & & & \\ \hline Sold for cash & & 50.00% & & & F & \\ \hline Credit sales collection per month & & 40.008 & 60.00% & & & \\ \hline \end{tabular} Storm Tools, Inc. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Sales Budget } \\ \hline & January & February & March & April & Quarter \\ \hline Units sold & 15,000 & 25,000 & 25,000 & 30,000 & 6. \\ \hline Sales price per unit & $125 & $125 & $125 & $125 & \\ \hline Sales & $1,875,000 & $3,125,000 & $3,125,000 & $3,750,000 & 8,12 \\ \hline \end{tabular} Assumptions Calcultion A B C D Storm Tools has formed a new business unit to produce battery-powered drills. The business unit was formed by the transfer of selected assets and obligations from the parent company. The unit's initial balance sheet on January 1 contained cash ($500,000), plant and equipment ($2,500,000), notes payable to the parent ($1,000,000), and residual equity ($2,000,000). The business unit is expected to repay the note at $0,000 per month, plus all accrued interest at 1/2% per month. Payments are made on the last day of each month. The unit is scheduled to produce 25,000 drills during January, with an increase of 2,500 units per month for the next three months. Each drill requires $40 of raw materials. Raw materials are purchased on account, and pald in the month following the month of purchase. The plant manager has established a goal to end each month with raw materials on hand, sufficient to meet 25% of the following month's planned production. The unit expects to sell 20,000 drills in January; 25,000 in February, 25,000 in March, and 30,000 per month thereafter. The selling price is $100 per drill. Half of the drills will be sold for cash through a website. The others will be sold to retallers on account, who pay 4005 in the month of purchase, and 6096 in the following month. Uncollectible accounts are not material. Each drill requires 20 minutes of direct labor to assemble. Labor rates are $24 per hour. Variable factory overhead is applied at $9 per direct labor hour. The fixed factory overhead is $25,000 per month; 60% of this amount is related to depreciation of plant and equipment. With the exception of depreciation, all overhead is funded as incurred. Selling general, and administrative costs are funded in cash as incurred, and consist of foxed components (salaries, $100,000; office, $40,000; and advertisine, $75,000 ) and variable components (15\% of sales). Prepare a monthly comprehensive budget plan for Storm's new business unit for January through March. The plan should include the (a) sales and cash collections budget, (b) production budget, (c) direct materials purchases and payments budget, (d) direct labor budget, (e) factory overhead budget, (f) ending finished goods budget (assume total factory overhead is applied to production at the rate of $11.73 per direct labor hour), ( g ) SG\&A budget, and (h) cash budget. Each person must complete a master budget using linking spreadsheets in Google Sheets. This is a free web-based electronic spreadsheet that is similar to Microsoft Excel. The variables, assumptions and requirements are detailed in Chapter 21 , Involved 21.02E. In addition to the required budgets, you must create the budgeted financial statements (Income Statement, Statement of Retained Earnings and Balance Sheet). The purpose of this project is to assess your level of knowledge of the master budget process and your ability to create a simple master budget using an electronic spreadsheet. If you are not an experienced spreadsheet user, this project will take longer because you will need to learn some basic spreadsheet skills. We will spend some class time on the basics, but if you are a beginner, this is a good excuse to invest some time building your electronic spreadsheet skills. This project assesses your knowledge of master budgets and electronic spreadsheets. An experienced spreadsheet user would finish this assignment in 3-4 hours. If you are not an experienced spreadsheet user, the amount of time required could more than double. \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & c & D & E & F & G \\ \hline \multicolumn{7}{|c|}{ Storm Tools, inc. } \\ \hline \multicolumn{7}{|c|}{ Sales Collections Budget } \\ \hline & & January & February & March & April & Quarter 1 \\ \hline Sales & & $1,875,000 & $3,125,000 & $3,125,000 & $3,750,000 & 8,125,000 \\ \hline Sold for Cash & & $937,500 & $1,$62,500 & $1,562,500 & $1,875,000 & $4,062,500 \\ \hline Sold on Credit (Accounts receivable) & & $937,500 & $1,562,500 & $1,562,500 & $1,875,000 & 54,062,500 \\ \hline Cash Collection month of sale & & $375,000 & $625,000 & $625,000 & $750,000 & $1,625,000 \\ \hline Cash Collection subsequent month & & & $562,500 & $937,500 & $937,500 & 1500000 \\ \hline Totalcollection & & $375,000 & $1,187,500 & $1,$62,500 & $1,687,500 & $3,125,000 \\ \hline Accounts receivable & & $562,500 & $937,500 & $937,500 & & $937,500 \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Assumptions } \\ \hline Calcultion & & & & & & \\ \hline \multicolumn{7}{|l|}{ Sales Budget } \\ \hline & & & & & & \\ \hline Sold for cash & & 50.00% & & & F & \\ \hline Credit sales collection per month & & 40.008 & 60.00% & & & \\ \hline \end{tabular} Storm Tools, Inc. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Sales Budget } \\ \hline & January & February & March & April & Quarter \\ \hline Units sold & 15,000 & 25,000 & 25,000 & 30,000 & 6. \\ \hline Sales price per unit & $125 & $125 & $125 & $125 & \\ \hline Sales & $1,875,000 & $3,125,000 & $3,125,000 & $3,750,000 & 8,12 \\ \hline \end{tabular} Assumptions Calcultion