Prepare Aaron’s production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables.

Aaron Furniture builds high-end hand-made dining tables. Attacus Simmons, the company’s owner, has developed the following sales forecast for 2022.

 

1st quarter 2nd quarter 3rd quarter 4th quarter
Forecasted sales (tables) 2,700 3,000 2,800 1,900

 

Because of the time needed to create each table, Aaron maintains an ending Finished Goods Inventory of 20% of the following quarter’s budgeted sales. Aaron has been following this inventory policy for several years. The company ended 2021 with 475 tables on hand.

The standard cost card for a table is as follows:

 

Standard Standard Total Standard Cost
Quantity Price
American cherry wood 20 board feet $4/board foot $80
American cherry turning square (legs) 4 squares $8/square 32
Direct labor 8 DLH $15/DLH 120
Variable overhead 8 DLH $45/DLH 360
Fixed overhead 8 DLH $12/DLH 96
$688

 

Required:

1. Prepare Aaron’s production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables. (3)

2. Aaron maintains inventory of American cherry wood equal to 5% of the following quarter’s production needs. On December 31, 2021, Aaron’s physical inventory count showed 4,800 board feet of American cherry. Due to an anticipated price increase in 2023, managers want to have 5,000 board feet of American cherry wood in inventory on December 31, 2022. Prepare Aaron’s 2022 direct materials purchases budget for the American cherry wood. (3)

Prepare Aaron’s direct labor budget for 2022.

find the cost of your paper

What is the basis for the rhythmicity observed in the SCN?

1.Why do you think animals, including humans, would evolve a system in which their testosterone levels would fluctuate with winning and losing in competitive situations? 2. How do shift work,….

establish the composition of the sources of funds that goes to make up the current capital structure of the trust.

funding arrangements (i.e. raise capital) for an Australian Real Estate Investment Trust (REIT) which is required to fund a new acquisition (thinking of buying another property) valued at AUD$1 billion…..

Identify the benefits of using futures for hedging, speculating and arbitraging with real examples.

Appendix Financial Engineering and Risk Management Individual Written Essay Report – 50%   Questions Futures: Identify the benefits of using futures for hedging, speculating and arbitraging with real examples. Explore….