Question
The Acme Company is a manufacturer of coffee tables. Acme has two product lines: the Family Room (FR) table (a larger table) and the Living
The Acme Company is a manufacturer of coffee tables. Acme has two product lines: the Family Room (FR) table (a larger table) and the Living Room (LR) table (a smaller table built with more expensive wood). The primary raw materials are wood, glass table top sheets, and decorative knobs. Each FR table requires ten feet of wood and the LR table requires eight feet of a more expensive wood. Acme makes both FR and LR table tops out of the same glass sheets but there is more waste when making LR table tops. Each FR table requires five decorative knobs and the LR table requires only three decorative knobs. Other raw materials, such as screws and glue, are insignificant in cost and are treated as indirect material.
Acmes controller is preparing the annual master budget for 2021 and has gathered the following information:
- Sales in the fourth quarter of 2020 are expected to be 45,000 FR tables and 41,000 LR tables. The sales manager predicts that over the next two years the sales in each product line will increase by 6,000 units each quarter over the previous quarter (first quarter 2021 sales will increase from the fourth quarter 2020 sales referred to herein). This forecast is based on a review of the historical sales data over the past five years.
- Acmes sales history shows that 85% of all sales are on credit, with the remainder in cash. The companys collection experience shows that 75% of credit sales are collected during the quarter in which the sale is made, while 25% is collected in the following quarter. (100% of Acmes receivables are collectable.)
- Currently, the FR table sells for $325 and the LR table sells for $490. These prices are expected remain constant at these levels throughout 2021.
- Acmes production manager attempts to end each quarter with enough finished goods inventory to cover 28% of the next quarters sales. Direct materials are delivered on a just in time basis (no inventory).
- All Acme direct material purchase are made on account and 85% of each quarters purchases are paid in cash during the same quarter as the purchase. The other 15% is paid in the following quarter. Payments made in the first quarter of 2021 for direct materials purchased in the fourth quarter of 2020 will amount to $1,793,344.
- Indirect materials are purchased as needed and paid for in cash. Work in process inventory is negligible (none).
- The predetermined overhead rate is $8 per direct labor hour. The following manufacturing Overhead costs are budgeted for 2021:
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Entire Year |
Indirect Material | $327,532 | $353,750 | $382,100 | $412,500 | $1,475,882 |
Indirect labor | 848,300 | 916,200 | 989,400 | 1,060,000 | 3,813,900 |
Depreciation | 510,000 | 510,000 | 510,000 | 510,000 | 2,040,000 |
Other overhead | 565,432 | 740,114 | 907,364 | 1,075,164 | 3,288,074 |
Total Overhead | $2,251,264 | $2,520,064 | $2,788,864 | $3,057,664 | $10,617 ,856 |
All of these costs will be paid in cash, except for depreciation.
- Acmes quarterly selling and administrative expenses will be $8,625,000 and $8,150,000 respectively, paid in cash.
- The company anticipates that dividends of $600,000 will be declared and paid in cash each quarter.
- The 2021 projected manufacturing costs are as follows: (the costs take into account the new machinery)
Direct material:
Wood:
FR table 10 feet @ $12 per foot
LR table 8 feet @ $16 per foot
Glass Sheets:
FR table 1 sheet @$9 per sheet
LR table 1 sheet @$9 per sheet
Decorative Knobs:
FR table 5 knobs @ $0.24 per knob
LR table 3 knobs @ $0.24 per knob
Direct Labor: .
FR table 2.2 hours at $21 per direct labor hour
LR table 3.4 hours at $24 per direct labor hour
Manufacturing overhead: $8 per direct labor hour.
11. The company is planning to purchase new machinery to make the production process more efficient. The machinery will cost $15,000,000 and they plan to finance the purchase with a five year loan from Rockland bank. On January 2, 2021, they will receive the proceeds of the loan and purchase and begin operating the machinery. The loan will be repaid in 20 equal principle installments on the last day of each quarter. The interest rate will be 6% per year and the interest payments will be made on the last day of each quarter as well.
12. Acmes balance sheet as of December 31, 2020 will be as follows:
Cash | $446,200 | Accounts Payable | $1,793,344 |
Accounts receivable | 7,376,938 | Total Liabilities | 1,793,344 |
Inventory: |
| Common Stock | 50,050,000 |
Raw Materials | 0 | Retained Earnings | 41,994,317 |
Finished Goods | 6,014,523 | Total Stockholders Equity | 92,044,317 |
Plant & Equipment (net of Accumulated Depreciation | 80,000,000 | Total Liabilities and Stockholders Equity | $93,837,661 |
Total Assets | $93,837,661 |
|
|
Required:
In your role as Acmes budget director, after receiving input from the various department heads, prepare the Acme company annual Master Budget for 2021 by completing the following quarterly schedules (with annual totals shown for 2021).
Important: You will need to do a 2020 fourth quarter schedule for several of the items below in order to budget out the 2021 amounts:
G.Prepare a budgeted Schedule of cost of goods manufactured and a budgeted Schedule of cost of goods sold for 2021 (Hint: actual and applied overhead will be equal).
H.Prepare a budgeted Income Statement for 2021.
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