Answered step by step
Verified Expert Solution
Question
1 Approved Answer
answer for i,j ,k ,l parts plz on the bases of july ,august, September and total ,or if quarter needed for these answer Auto Parts
answer for i,j ,k ,l parts plz on the bases of july ,august, September and total ,or if quarter needed for these answer
Auto Parts Ltd is a worldwide part manufacturing firm based in North America After many years in the market, the Peterborough division, which produces one product called "Auto Parts# 857," reached a spike in the sales level. The Management wants to have a significant investment to expand the facility and increase production, but it is requesting the division prepare a budget for the third quarter of 2022. Sales Budget July September Total Units 180 Price Total Sales $ ss 120 $ August 5 $ 5 $ 600 $ 750 $ The actual sales from 2022 are May 52,000 units June 90,000 units The division manager projected the following sales: July 2022 105,000 units August 2022 225,000 units September 2022 122,000 units October 2022 157,000 units November 2022 162,000 units The selling price is $12 per unit 1. From previous experience, Management has determined that finished goods ending inventory equal to 25% of the next month's unit sales are required to fit the buyer's demands. 150 450 5 2,250 5 $ 900 $ 2. Part# 857 requires one type of raw material: Plastic O Each Auto Part# 857 requires 1.6 kilograms of Plastic at the cost of $1.75 per kilogram. The supplier of Plastic tends to be somewhat erratic, so Auto Parts Ltd finds it necessary to maintain an inventory balance equal to 20% of the material needed for the next month as a precaution against stock-outs. The direct material on June 30 is 42,400 Kg. 3. The beginning accounts payable will consist of $113,680. 4. Auto Parts Ltd pays for 60% of a month's purchases in the month of purchase and 40% in the following month. 5. The manufacturing overhead is based on direct labour hours. The workers receive an average of $15.00 per hour, including employee benefits. Each Auto Parts# 857takes 12 minutes to complete. 6. Auto Parts Ltd allocates the manufacturing overhead based on direct labour hours; The variable manufacturing overhead is as follows: Maintenance $0.40; Utilities $0.60; Indirect Labor $0.60; Indirect materials $0.40 7. The Monthly Fixed manufacturing overhead costs are as follows: $2,500 Janitorial Insurance $1,750 Depreciation $15,200 Property Taxes $2,100 Salaries $44,800 Three months' property taxes are prepaid on the first day of the first month of the quarter. 8. Auto Parts Ltd allocates the selling and administration expenses based on unit sales, The variable sellingand administration rate is $1.5 per unit of sales. 9. The Monthly Selling and administrative expenses are Salaries $62,100 Other fixed costs $4,600 Insurance $1,200 Depreciation $2,800 Advertising $12,000 10. Sales are on account (credit); 60% of the sales are collected during the month of sales and 40% the following month. This was the same collection pattern as in previous years. 11. The company wants to maintain at the end of each month a minimum bank balance of $1,000,000.In case the company has a deficiency of money or is not able to reach this minimum bank balance, the company can borrow from a line of credit at the rate of 12% per annum.All borrowing is considered to happen on the first day of the month, and repayments are on the last day of the month.All borrowings and repayments from the bank should be in multiples of $5,000.It pays interest monthly. The cash balance on June 30 is $184,000. 12. In August, $950,000 of new equipment to update operations will be purchased with cash. 13. Three months' insurance is prepaid on the first day of the first month of the quarter.In addition, at the end of each quarter, the company pays $250,000 in dividends. 14.The company has a Common stock beginning balance is $150,840.The Retained Earnings Beginning Balance $600,507. Required Prepare 2022, Third Quarter Master Budget for Auto Parts Ltd for the including the following schedules: Prepare the following Schedules (in this order) a) Prepare the Sales Budget for the third quarter (textbook Illustration 10.3) b) Prepare the Schedule of Expected Collection from Customers for the third quarter (Illustration 10.17) c) Prepare the Production Budget for the third quarter (Illustration 10.5) d) e) Prepare the Direct Materials Budget for the third quarter (Illustration 10.9) Prepare the Expected Direct Material Cash Disbursements for the third quarter (Illustration 10.18) f) Prepare the Direct Labour Budget for the third quarter (Illustration 10.11) g) Prepare the Manufacturing Overhead Budget for the third quarter (Illustration 10.12) Prepare the Unit cost (Illustration 10.14) h) i) Prepare the Selling and Administrative Expenses Budget for the third quarter (Illustration 10.13) j) Prepare the Cash Budget for the third quarter (Illustration 10.19) k) Prepare the income statement (illustration 10.15) 1) Prepare the statement of financial position (Illustration 10.21) Auto Parts Ltd is a worldwide part manufacturing firm based in North America After many years in the market, the Peterborough division, which produces one product called "Auto Parts# 857," reached a spike in the sales level. The Management wants to have a significant investment to expand the facility and increase production, but it is requesting the division prepare a budget for the third quarter of 2022. Sales Budget July September Total Units 180 Price Total Sales $ ss 120 $ August 5 $ 5 $ 600 $ 750 $ The actual sales from 2022 are May 52,000 units June 90,000 units The division manager projected the following sales: July 2022 105,000 units August 2022 225,000 units September 2022 122,000 units October 2022 157,000 units November 2022 162,000 units The selling price is $12 per unit 1. From previous experience, Management has determined that finished goods ending inventory equal to 25% of the next month's unit sales are required to fit the buyer's demands. 150 450 5 2,250 5 $ 900 $ 2. Part# 857 requires one type of raw material: Plastic O Each Auto Part# 857 requires 1.6 kilograms of Plastic at the cost of $1.75 per kilogram. The supplier of Plastic tends to be somewhat erratic, so Auto Parts Ltd finds it necessary to maintain an inventory balance equal to 20% of the material needed for the next month as a precaution against stock-outs. The direct material on June 30 is 42,400 Kg. 3. The beginning accounts payable will consist of $113,680. 4. Auto Parts Ltd pays for 60% of a month's purchases in the month of purchase and 40% in the following month. 5. The manufacturing overhead is based on direct labour hours. The workers receive an average of $15.00 per hour, including employee benefits. Each Auto Parts# 857takes 12 minutes to complete. 6. Auto Parts Ltd allocates the manufacturing overhead based on direct labour hours; The variable manufacturing overhead is as follows: Maintenance $0.40; Utilities $0.60; Indirect Labor $0.60; Indirect materials $0.40 7. The Monthly Fixed manufacturing overhead costs are as follows: $2,500 Janitorial Insurance $1,750 Depreciation $15,200 Property Taxes $2,100 Salaries $44,800 Three months' property taxes are prepaid on the first day of the first month of the quarter. 8. Auto Parts Ltd allocates the selling and administration expenses based on unit sales, The variable sellingand administration rate is $1.5 per unit of sales. 9. The Monthly Selling and administrative expenses are Salaries $62,100 Other fixed costs $4,600 Insurance $1,200 Depreciation $2,800 Advertising $12,000 10. Sales are on account (credit); 60% of the sales are collected during the month of sales and 40% the following month. This was the same collection pattern as in previous years. 11. The company wants to maintain at the end of each month a minimum bank balance of $1,000,000.In case the company has a deficiency of money or is not able to reach this minimum bank balance, the company can borrow from a line of credit at the rate of 12% per annum.All borrowing is considered to happen on the first day of the month, and repayments are on the last day of the month.All borrowings and repayments from the bank should be in multiples of $5,000.It pays interest monthly. The cash balance on June 30 is $184,000. 12. In August, $950,000 of new equipment to update operations will be purchased with cash. 13. Three months' insurance is prepaid on the first day of the first month of the quarter.In addition, at the end of each quarter, the company pays $250,000 in dividends. 14.The company has a Common stock beginning balance is $150,840.The Retained Earnings Beginning Balance $600,507. Required Prepare 2022, Third Quarter Master Budget for Auto Parts Ltd for the including the following schedules: Prepare the following Schedules (in this order) a) Prepare the Sales Budget for the third quarter (textbook Illustration 10.3) b) Prepare the Schedule of Expected Collection from Customers for the third quarter (Illustration 10.17) c) Prepare the Production Budget for the third quarter (Illustration 10.5) d) e) Prepare the Direct Materials Budget for the third quarter (Illustration 10.9) Prepare the Expected Direct Material Cash Disbursements for the third quarter (Illustration 10.18) f) Prepare the Direct Labour Budget for the third quarter (Illustration 10.11) g) Prepare the Manufacturing Overhead Budget for the third quarter (Illustration 10.12) Prepare the Unit cost (Illustration 10.14) h) i) Prepare the Selling and Administrative Expenses Budget for the third quarter (Illustration 10.13) j) Prepare the Cash Budget for the third quarter (Illustration 10.19) k) Prepare the income statement (illustration 10.15) 1) Prepare the statement of financial position (Illustration 10.21)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