Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Coronado Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast for 2022. 1st Quarter 2nd Quarter 3rd

Coronado Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast for 2022.

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Forecasted sales (tables)

2,600 3,000 2,800 1,900

Because of the time needed to create each table, Coronado maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Coronado has been following this inventory policy for several years. The company ended 2021 with 450 tables on hand. The standard cost card for a table is as follows:

Standard Quantity

Standard Price

Total Standard Cost

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

(a)

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is partially correct.

Prepare Coronados production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables.

Production Budget

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Annual

select an opening production budget item Budgeted unit salesBeginning inventoryBudgeted productionTotal units requiredBudgeted ending inventory

enter a number of units

enter a number of units

enter a number of units

enter a number of units

enter a number of units

select a production budget item Beginning inventoryTotal units requiredBudgeted ending inventoryBudgeted productionBudgeted unit sales

enter a number of units

enter a number of units

enter a number of units

enter a number of units

enter a number of units

select a summarizing line for the first part Budgeted ProductionBeginning inventoryBudgeted ending inventoryTotal units requiredBudgeted unit sales

enter a total number of units for the first part

enter a total number of units for the first part

enter a total number of units for the first part

enter a total number of units for the first part

enter a total number of units for the first part

select a production budget item Budgeted productionBeginning inventoryTotal units requiredBudgeted ending inventoryBudgeted unit sales

enter a number of units

enter a number of units

enter a number of units

enter a number of units

enter a number of units

select a closing production budget item Budgeted unit salesTotal units requiredBudgeted ProductionBudgeted ending inventoryBeginning inventory

enter a total number of units

enter a total number of units

enter a total number of units

enter a total number of units

enter a total number of units

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

Cloud Security Auditing

Authors: Suryadipta Majumdar, Taous Madi, Yushun Wang, Azadeh Tabiban, Momen Oqaily, Amir Alimohammadifar, Yosr Jarraya, Makan Pourzandi, Lingyu Wang, Mourad Debbabi

1st Edition

3030231305, 978-3030231309

More Books

Students also viewed these Accounting questions

Question

Why We Form Relationships Managing Relationship Dynamics?

Answered: 1 week ago