Reference no: EM132300609
Question One
Beckett Pumps is a manufacturer of commercial and heavy industrial Pumps. The firm's two product lines are called Directlift and Gravity. The primary raw materials are flexible steel sheet, and 23cm x 60cm of plastic sheets. Each Directlift pump requires a 2/3 of a metre and a Gravity pump requires a one metre of steel sheet. Allowing for normal breakage, the company can cut either enough to make four Directlifts or two Gravity pumps from a single plastic sheet. Other raw materials are costly and treated as indirect materials. Jo Smith Beckett Pump's accountant has gathered the following information in preparation for the company's annual budget for the next year.
• Sales in the fourth quarter of the current year are expected to be 50,000 Directlift and 40,000 Gravity pumps. The sales manager predicts that, over the next two years, sales in each product line will grow by 5000 units each quarter over the previous quarter. For example, Directlift sales in the first quarter of the budget year are expected to be 55,000 units.
• Beckett's sales history indicates that 60 per cent of all sales are on credit, with the remainder of the sales in cash. The company's experience shows that 80 per cent of the credit sales are collected during the quarter in which the sales are made, while the remaining 20 per cent are collected in the following quarter, there are no bad debts.
• The Directlift sells for $10 and Gravity for $15. These prices are not to change throughout the budget year.
• Beckett's production manager tries to end each quarter with enough finished goods inventory in each product line to cover 20 per cent of the following quarter's sales. In addition, an attempt is made to end each quarter with 20 per cent of the plastic sheets needed for the following quarter's production. Since steel sheets are purchased locally, Beckett buys them on a just-in-time basis, so inventory is negligible.
• All of Beckett's direct material purchases are on credit, and 80 per cent of each quarter's purchases are paid in cash during the same quarter as the purchases are made. The other 20 per cent are paid in the next quarter.
• Indirect materials are purchased as needed for cash.
• Work in process inventory in negligible.
• Projected manufacturing costs for each product in the budget year are as follows:
|
Directlift
|
Gravity
|
Direct material
|
|
|
Steel sheet:
|
|
|
Directlift: 2/3 metre @$3 per metre
|
$2
|
|
Gravity: 1 metre @ $3 per metre
|
|
$3
|
Plastic sheet:
|
|
|
Directlift: ¼ sheet @$8 per sheet
|
2
|
|
Gravity: ½ sheet @ $8 per sheet
|
|
4
|
Direct labour:
|
|
|
0.1 hour @ $20 per hour
|
2
|
2
|
Manufacturing overhead:
|
|
|
0.1 direct labour hour @ $10 per hour
|
1
|
1
|
Total manufacturing cost per unit
|
$7
|
$10
|
• The predetermined overhead rate is $10 per direct labour hour. The following manufacturing overhead costs (all these costs except for the depreciation charges will be paid in cash during the quarter incurred) are busgeted:
|
1st quarter
|
2nd quarter
|
3rd quarter
|
4th quarter
|
Entire year
|
Indirect material
|
$10200
|
$11200
|
$12200
|
$13200
|
$46800
|
Indirect labour
|
40800
|
44800
|
48800
|
52800
|
187200
|
Other overhead
|
31000
|
36000
|
41000
|
46000
|
154000
|
Depreciation
|
20000
|
20000
|
20000
|
20000
|
80000
|
Total overhead
|
$102000
|
$112000
|
$122000
|
$132000
|
$468000
|
• Beckett pump's quarterly selling and administrative expenses are $100,000 paid in cash
• Jo Smith anticipates that dividends of $50,000 will be declared and paid in cash each quarter.
• Beckett's projected balance sheet as 31 December of the current year is as follows:
Cash
|
$95000
|
Accounts receivable
|
132000
|
Inventory:
|
|
Raw materials
|
59200
|
Finished goods
|
167000
|
Plant and equipment (net of accumulated depreciation)
|
8 000 000
|
Total assets
|
$8 453 200
|
Accounts payable
|
$99400
|
Ordinary shares
|
5 000 000
|
Retained earnings
|
3 353 800
|
Total liabilities and shareholders' equity
|
$8 453 200
|
Additional information:
The CEO has decided to invest in purchasing in a fully automated electric machine which is expected to increase production significantly. The acquisition of the new machine will take place at the start of January next year. The machine will cost $950,000 and there will be an additional $50,000 of equipment purchase to allow the machine to operate. The purchase will be financed with a $1,000,000 loan from National Australia Bank. The CEO has negotiated a repayment schedule of four equal instalments, payable on the last day of each quarter. The interest rate is 10 per cent and interest is also paid quarterly.
Required:
Prepare Beckett Pump's annual budget for the next year by completing:
- Sales budget
- Cash receipt budget
- Production budget
- Direct material budget
- Cash payments budget
- Cash budget
- Budgeted schedule of cost of goods manufactured and sold (hint: in the budget, actual and applied overhead will be equal) (5 marks)
- Budgeted income statement (ignore income tax)
- Budgeted balance sheet as of 31 December of the budget year
Research a person that advocate against inequality
: Using the Internet, research a significant person that was/is an advocate against inequality. Discuss what led him or her to become an advocate
|
Write a reflection paper that highlights learning experience
: Write a 2-page reflection paper that highlights your learning experience of that particular documentary/movie and how it relates to what you've learned.
|
Summarize personal and general experience with the reading
: Summarize your personal and general experience with the reading, readings, performance, or concept involved in your chosen question (How did it make you feel?
|
Create a photo essay that depicts the economic struggles
: SOC 1010 Photo Essay Assignment - Create a photo essay that depicts the economic struggles that many Americans are facing today
|
Prepare beckett pumps annual budget
: ACT502 Management Accounting - Charles Darwin University - Prepare Beckett Pumps annual budget for the next year - udgeted schedule of cost of goods manufacture
|
What was the dispute in the case you chose
: What was the dispute in the case you chose? (Don't tell the whole story. I know it. Just tell me enough that I can see that you actually read and understand.
|
Apple that failed during steps of new product development
: Research a product or idea from a company such as Microsoft, Google, or Apple that failed during the steps of new product development.
|
Do you support way forward for american healthcare system
: One of the most divisive and economically pressing questions in U.S. domestic policy over the last several decades has been healthcare. The United States spends
|
Differences between successful leaders in public and private
: What are the differences, if any, between successful leaders in public, private, and non-profit organizations? Cite experiences and research to support.
|