Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Full answer for Q1 and Q2 with detailed explanation please, thank you!!! The Supersonic Company The Supersonic Company is a machine shop that uses skilled

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Full answer for Q1 and Q2 with detailed explanation please, thank you!!!

The Supersonic Company The Supersonic Company is a machine shop that uses skilled labor and specified metal alloys for manufacturing aircraft replacement parts. The Company's Planning, Budgeting, and Resources (PBR) Department provides the following forecast information: Direct materials: Material X111 alloy Material Y112 alloy $7.00 per kilogram S10 per kilogram Direct labor: $20 per hour Factory overhead is allocated on the basis of direct labor hours. It is assumed that a single cost driver, direct labor hours, is used as an application base for applying all factory overhead. The production steps are labor-paced. That is, worker skills and productivity determine the speed of manufacturing. In addition, work-in-process inventories are negligible and are ignored. Unit prices of direct materials and finished goods remain unchanged. Products Product R Product HD (Regular aireraft parts) (Heavy-Duty aircraft parts) Finished goods: (content of each unit) Direct Material X111 alloy Direct Material Y112 alloy Direct labor 12 Kilograms 6 Kilograms 4 hours 12 Kilograms 8 Kilograms 6 hours Additional information regarding the year 2020: Products Product R Product HD (Regular aircraft parts) (Heavy-Duty aircraft parts) 5,000 1,000 $600 1,100 100 $38,400 $26,200 Expected sales in units Selling price per unit Target ending inventory in units * Beginning inventory in units Beginning inventory in dollars $800 50 Direct Materials Y112 6,000 2,000 X111 7,000 8,000 Beginning inventory in kilograms Target ending inventory in kilograms * * Target inventories are affected by management policies regarding relations with suppliers and expected sales. amputed volume levels. the PRR D e t believes the following costs will be incurred: Factory Overhead: Supplies Indirect labor Payroll fringe costs Power - variable portion Power-fixed portion Maintenance - variable portion Maintenance-fixed portion Depreciation Property taxes Property insurance Supervision Total $ 90,000 200,000 320,000 90,000 20,000 70,000 20,000 230,000 50,000 10,000 100,000 1,200,000 Marketing and Administration Expenses: Sales commissions Advertising Sales and customer service salaries Travel Clerical wages Supplies Officer salaries Miscellaneous Total $200,000 60,000 100,000 90,000 100,000 12,000 260,000 48,000 $870,000 Budgeted cash flows are: Quarters 3 $900,000 $995,000 $795,000 $910,000 Collections from customers Disbursements: For direct materials For others costs and expenses For payroll For income taxes For machinery purchase 240,000 250,000 320,000 80,000 230,000 240,000 380,000 50,000 260,000 190,000 410,000 35,000 240,000 180,000 340,000 55,000 84,810 The company desires to maintain a $35,000 minimum cash balance at the end of each quarter. Money can be borrowed or repaid in multiples of $1,000 at an interest rate of 12% per year, Management does not want to borrow any more cash than is necessary and wants to repay as promptly as possible. In any event, loans may not extend beyond four quarters. By special arrangement, interest is computed and paid when the principal is repaid. Assume that borrowings take place at the beginning and repayments at the end of the quarters in question. Compute interest to the nearest dollars. Required: 1. Prepare the following budgets for The Supersonic Company for The Supersonic Company for 2020. Sales budget; Production budget (in units); Direct materials usage budget; Direct labor budget; Factory overhead budget; Ending inventory budget; Cost of goods sold budget; Marketing and administrative expense budget; Budgeted income statement 2. Prepare a cash budget by quarters and total, including details of borrowings, repayments, and interest. The Supersonic Company The Supersonic Company is a machine shop that uses skilled labor and specified metal alloys for manufacturing aircraft replacement parts. The Company's Planning, Budgeting, and Resources (PBR) Department provides the following forecast information: Direct materials: Material X111 alloy Material Y112 alloy $7.00 per kilogram S10 per kilogram Direct labor: $20 per hour Factory overhead is allocated on the basis of direct labor hours. It is assumed that a single cost driver, direct labor hours, is used as an application base for applying all factory overhead. The production steps are labor-paced. That is, worker skills and productivity determine the speed of manufacturing. In addition, work-in-process inventories are negligible and are ignored. Unit prices of direct materials and finished goods remain unchanged. Products Product R Product HD (Regular aireraft parts) (Heavy-Duty aircraft parts) Finished goods: (content of each unit) Direct Material X111 alloy Direct Material Y112 alloy Direct labor 12 Kilograms 6 Kilograms 4 hours 12 Kilograms 8 Kilograms 6 hours Additional information regarding the year 2020: Products Product R Product HD (Regular aircraft parts) (Heavy-Duty aircraft parts) 5,000 1,000 $600 1,100 100 $38,400 $26,200 Expected sales in units Selling price per unit Target ending inventory in units * Beginning inventory in units Beginning inventory in dollars $800 50 Direct Materials Y112 6,000 2,000 X111 7,000 8,000 Beginning inventory in kilograms Target ending inventory in kilograms * * Target inventories are affected by management policies regarding relations with suppliers and expected sales. amputed volume levels. the PRR D e t believes the following costs will be incurred: Factory Overhead: Supplies Indirect labor Payroll fringe costs Power - variable portion Power-fixed portion Maintenance - variable portion Maintenance-fixed portion Depreciation Property taxes Property insurance Supervision Total $ 90,000 200,000 320,000 90,000 20,000 70,000 20,000 230,000 50,000 10,000 100,000 1,200,000 Marketing and Administration Expenses: Sales commissions Advertising Sales and customer service salaries Travel Clerical wages Supplies Officer salaries Miscellaneous Total $200,000 60,000 100,000 90,000 100,000 12,000 260,000 48,000 $870,000 Budgeted cash flows are: Quarters 3 $900,000 $995,000 $795,000 $910,000 Collections from customers Disbursements: For direct materials For others costs and expenses For payroll For income taxes For machinery purchase 240,000 250,000 320,000 80,000 230,000 240,000 380,000 50,000 260,000 190,000 410,000 35,000 240,000 180,000 340,000 55,000 84,810 The company desires to maintain a $35,000 minimum cash balance at the end of each quarter. Money can be borrowed or repaid in multiples of $1,000 at an interest rate of 12% per year, Management does not want to borrow any more cash than is necessary and wants to repay as promptly as possible. In any event, loans may not extend beyond four quarters. By special arrangement, interest is computed and paid when the principal is repaid. Assume that borrowings take place at the beginning and repayments at the end of the quarters in question. Compute interest to the nearest dollars. Required: 1. Prepare the following budgets for The Supersonic Company for The Supersonic Company for 2020. Sales budget; Production budget (in units); Direct materials usage budget; Direct labor budget; Factory overhead budget; Ending inventory budget; Cost of goods sold budget; Marketing and administrative expense budget; Budgeted income statement 2. Prepare a cash budget by quarters and total, including details of borrowings, repayments, and interest

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The TL 9000 Guide For Auditors

Authors: Mark Kempf

1st Edition

087389510X, 978-0873895101

More Books

Students also viewed these Accounting questions