Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The DecorIdeas Company manufactures hand-crafted natural wood display cupboards. Currently the company makes only one size of display cupboard, which is 60-inch height, 48-inch

image text in transcribed
image text in transcribed
1. The DecorIdeas Company manufactures hand-crafted natural wood display cupboards. Currently the company makes only one size of display cupboard, which is 60-inch height, 48-inch width, and 19-inch depth; and has 6 shelves. The final product consists of a routed, sanded, assembled, and stained oak wood cupboard. Direct materials include oak shelving wood and hickory plywood backing board. Other materials, such as wood screws, sand paper, stain, wood glue, and packaging. are treated as indirect materials. Decorldeas is preparing budgets for the fourth quarter ending December 31, 2022. For each requirement below prepare budgets by month for October, November, and December; and a total budget for the quarter. The previous year's sales (2021/22) for the corresponding period were: 6. Variable selling and administrative expenses are $100.50 per display cupboard sold. Fixed selling and administrative expenses are $80,000 per month. These costs are not itemized, i.e., the budget has only two line items - variable operating expenses and fixed operating expenses. Prepare an Operating Expenses budget. 7. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMOH/unit calculate total FMOH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 50,000 display cupboards. 8. Prepare a Budgeted Income Statement for the quarter for Decorideas. Assume interest expense of \$0, and income tax expense of 24% of income before taxes. DecorIdeas's goal for the quarter is to make its net income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use@IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to 'Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue* 10% ) is met or not

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

Students also viewed these Accounting questions

Question

Why is color vision deficiency a better term than color blindness?

Answered: 1 week ago

Question

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago