Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I know it's alot but can you please show a step by step solution? 1. Prepare the July 2022 Production Budget (in units). 2. Prepare
I know it's alot but can you please show a step by step solution?
1. Prepare the July 2022 "Production Budget" (in units). 2. Prepare the "Direct Materials Budget" for July 2022. 3. Prepare the "Direct Labor Budget" for July 2022. 4. Prepare the "Schedule of Budgeted Manufacturing Overhead" for July 2022. 5. Prepare the "Budgeted Statement of Cost of Goods Sold" for July 2022. 6. Prepare the "Schedule of Budgeted Marketing and Administrative Costs" for July 2022 7. Prepare the "Budgeted Income Statement" for July 2022 8. Prepare the "Cash Budget" for July 2022. 9. Prepare a "budgeted balance sheet" for July 31,2022 by calculating the additions and subtractions for the month of July Fountain Boats, Inc. manufactures and sells boats. In June 2022, Fountain Boats controller gathered the following data to prepare the July 2022 budget. Estimated Direct Materials needed is 12 feet of fiberglass per boat and 14 yards of plastic per boat Estimated Direct manufacturing labor required is 6 hours per boat Fountain Boats Controller expects to sell 3,700 boats during July 2022 at an estimated retail price of $850 per boat. Further, the Controller expects July 2022 beginning inventory of 600 boats and would like to end July 2022 with 400 boats in stock. The beginning fiberglass inventory on July 1,2022 is expected to be 1,540 feet. and the ending balance is expected to be 2,000 feet. The June unit cost was $34.00 per foot and the July unit cos is projected to be $29.00 per foot. The beginning plastic inventory on July 1,2022 is expected to be 2,040 yards and the ending balance is expected to be 1,040 yards. The June unit cost was $9 per yard and the July cost is expected to be $7 per yard. Labor costs are $29 per hour in June and are expected to be $27 in July. Variable manufacturing overheard is $8 per direct manufacturing labor hour. Fixed manufacturing overhead costs budgeted for July 2022 are Labor $18,000, Maintenance, $22,000, Insurance $27,000 and property taxes of $15,000. Fountain Boats variable manufacturing overhead rate is based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $220 per sales visit. The marketing plan calls for 40 sales visits during July 2022 . Finally, fixed marketing costs budgeted for July 2022 are $6,000 for sales salaries and $8,000 in advertising. Administrative costs are expected to be $12,000 for administrative salaries, $5,000 for Legal and Accounting staff, $5,000 for data processing costs and $7,000 for depreciation. Finished-goods inventory on June 30, 2022 is valued $640.00 per unit. Assume Fountain Boat uses a weighted-average inventory method (not LIFO or FIFO) for finished goods. You will calculate the per unit by adding beginning inventory plus cost of goods manufactured and divide this by the units produced plus beginning units. Budgeted Balance Sheet balances as of June 30,2022 are as follows: Selected budget information for June 2022 follows: Customer invoices are payable within 30 days. From past experience, Fountain Boats accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchases. Fixed manufacturing overhead costs include $64,000 of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. There was not any property, plant, and equipment acquired during July 2022. There were no borrowings or repayments with respect to long-term liabilities in July 2022. On July 2, 2022, Fountain Boats board of directors declared a $160,00 dividend payable to stockholders of record on July 15,2022 . The Board actually paid $160,000 on July 31,2022 . 1. Prepare the July 2022 "Production Budget" (in units). 2. Prepare the "Direct Materials Budget" for July 2022. 3. Prepare the "Direct Labor Budget" for July 2022. 4. Prepare the "Schedule of Budgeted Manufacturing Overhead" for July 2022. 5. Prepare the "Budgeted Statement of Cost of Goods Sold" for July 2022. 6. Prepare the "Schedule of Budgeted Marketing and Administrative Costs" for July 2022 7. Prepare the "Budgeted Income Statement" for July 2022 8. Prepare the "Cash Budget" for July 2022. 9. Prepare a "budgeted balance sheet" for July 31,2022 by calculating the additions and subtractions for the month of July Fountain Boats, Inc. manufactures and sells boats. In June 2022, Fountain Boats controller gathered the following data to prepare the July 2022 budget. Estimated Direct Materials needed is 12 feet of fiberglass per boat and 14 yards of plastic per boat Estimated Direct manufacturing labor required is 6 hours per boat Fountain Boats Controller expects to sell 3,700 boats during July 2022 at an estimated retail price of $850 per boat. Further, the Controller expects July 2022 beginning inventory of 600 boats and would like to end July 2022 with 400 boats in stock. The beginning fiberglass inventory on July 1,2022 is expected to be 1,540 feet. and the ending balance is expected to be 2,000 feet. The June unit cost was $34.00 per foot and the July unit cos is projected to be $29.00 per foot. The beginning plastic inventory on July 1,2022 is expected to be 2,040 yards and the ending balance is expected to be 1,040 yards. The June unit cost was $9 per yard and the July cost is expected to be $7 per yard. Labor costs are $29 per hour in June and are expected to be $27 in July. Variable manufacturing overheard is $8 per direct manufacturing labor hour. Fixed manufacturing overhead costs budgeted for July 2022 are Labor $18,000, Maintenance, $22,000, Insurance $27,000 and property taxes of $15,000. Fountain Boats variable manufacturing overhead rate is based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $220 per sales visit. The marketing plan calls for 40 sales visits during July 2022 . Finally, fixed marketing costs budgeted for July 2022 are $6,000 for sales salaries and $8,000 in advertising. Administrative costs are expected to be $12,000 for administrative salaries, $5,000 for Legal and Accounting staff, $5,000 for data processing costs and $7,000 for depreciation. Finished-goods inventory on June 30, 2022 is valued $640.00 per unit. Assume Fountain Boat uses a weighted-average inventory method (not LIFO or FIFO) for finished goods. You will calculate the per unit by adding beginning inventory plus cost of goods manufactured and divide this by the units produced plus beginning units. Budgeted Balance Sheet balances as of June 30,2022 are as follows: Selected budget information for June 2022 follows: Customer invoices are payable within 30 days. From past experience, Fountain Boats accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchases. Fixed manufacturing overhead costs include $64,000 of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. There was not any property, plant, and equipment acquired during July 2022. There were no borrowings or repayments with respect to long-term liabilities in July 2022. On July 2, 2022, Fountain Boats board of directors declared a $160,00 dividend payable to stockholders of record on July 15,2022 . The Board actually paid $160,000 on July 31,2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started