Part 1 You have just been hired into an accounting position at Cooking Inc., which requires...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 1 You have just been hired into an accounting position at Cooking Inc., which requires the application of your budgeting skills. Cooking Inc. produces and sells toaster ovens and microwave airfryer ovens. The following data has been gathered to budget for 2024. 2024 projected sales Toaster ovens Microwave airfryer ovens 2024 Inventories in units Toaster ovens Microwave airfryer ovens Units Price 46,000 35,000 $85 130 Expected January Desired December 31, 1, 2024 2024 10,000 3,000 To produce one unit of each product, the following components are used: 12,000 5,000 Components Motor Switches Fuse Toaster ovens Microwave airfryer ovens 1 1 4 3 2 2 Projected data for 2024 with respect to components are as follows: Motor Switches Fuse Projected Purchase Price $20.00 Expected January 1, 2024 Desired December in units 31, 2024 in units 2,000 3.00 21,000 3,600 24,000 4.00 6,000 7,500 Projected direct labor replacements for 2024 and rates are as follows: Product Toaster ovens Microwave airfryer ovens Hours per unit Rate per hour 2 3 $15 16 Overhead is applied at a rate of $10.00 per direct labor hour Required: Prepare the following 2024 budgets on the Part 1 budget worksheet in order provided below. Use the this worksheet as your reference worksheet for cell referencing on the budget worksheet. The budget worksheet must only be cell references and formulas. You will need to provide clear labels and set up the budgets in good form. 1. Sales budget in dollars. 2. Production budget in units 3. Components purchase budget in units and dollars. 4. Direct labor budget in dollars. 5. Compute the budgeted production cost per unit of a toaster oven and a microwave airfryer oven. Part 1 You have just been hired into an accounting position at Cooking Inc., which requires the application of your budgeting skills. Cooking Inc. produces and sells toaster ovens and microwave airfryer ovens. The following data has been gathered to budget for 2024. 2024 projected sales Toaster ovens Microwave airfryer ovens 2024 Inventories in units Toaster ovens Microwave airfryer ovens Units Price 46,000 35,000 $85 130 Expected January Desired December 31, 1, 2024 2024 10,000 3,000 To produce one unit of each product, the following components are used: 12,000 5,000 Components Motor Switches Fuse Toaster ovens Microwave airfryer ovens 1 1 4 3 2 2 Projected data for 2024 with respect to components are as follows: Motor Switches Fuse Projected Purchase Price $20.00 Expected January 1, 2024 Desired December in units 31, 2024 in units 2,000 3.00 21,000 3,600 24,000 4.00 6,000 7,500 Projected direct labor replacements for 2024 and rates are as follows: Product Toaster ovens Microwave airfryer ovens Hours per unit Rate per hour 2 3 $15 16 Overhead is applied at a rate of $10.00 per direct labor hour Required: Prepare the following 2024 budgets on the Part 1 budget worksheet in order provided below. Use the this worksheet as your reference worksheet for cell referencing on the budget worksheet. The budget worksheet must only be cell references and formulas. You will need to provide clear labels and set up the budgets in good form. 1. Sales budget in dollars. 2. Production budget in units 3. Components purchase budget in units and dollars. 4. Direct labor budget in dollars. 5. Compute the budgeted production cost per unit of a toaster oven and a microwave airfryer oven.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Use Part 1 and the budgets that have been completed to fill out the empty budgets shown and answer question #7 and #9 Part 1 I have a template set up on the Budgetsolution worksheet that you should...
-
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company...
-
Find the eccentricity of the hyperbola. Then find and graph the hyperbolas foci and directrices. x 2 - y 2 = 1
-
One of the disadvantages associated with direct marketing media is the high cost per exposure. Some marketers feel that this cost is not really as much as a disadvantage as is claimed. Argue for or...
-
When a star between 9-25 solar masses reaches the end of its life, fusion in the core halts and the core can no longer withstand gravitational pressure. Gravity causes the ~2.5 solar mass core to...
-
True or False: The larger the accelerometer crystal, the lower the maximum frequency range.
-
What evidence can you provide to demonstrate that Etsys founders, Rob Kalin, Chris Maguird, Jared Tarbell, and Haim Schoppik, developed a disruptive business model as the foundation for launching...
-
The total sales of a company is $ 1 , 0 0 0 K . The company aims to increase its profit by 2 5 % . There are two ways to increase profit by 2 5 % , either by purchasing the raw materials at a lower...
-
Consider the second order Ordinary Differential Equation (ODE) y' + 5xy = 0, y(0) = y = ce-2.5x = T[ a) Verify that the function y(x) is the solution to the given ODE. (5 marks) b) Hence determine...
-
An aircraft factory manufactures airplane engines. The unit cost C (the cost in dollars to make each airplane engine ) depends on the number of engines made. If x engines are made, then the unit cost...
-
A company is increasing the production of a product at the rate of 25 units per week. The demand and cost functions for the product are given by p = 60 - 0.02x and C = 3000 + 20x - 0.04x^(2). Find...
-
ware Company reported the following: Manufacturing costs $2,000,000 50,000 47,000 units sold for $75 Units manufactured Units sold per unit Beginning inventory 0 units What is the average...
-
Emmett and Sierra formed a partnership dividing income as follows: 1. Annual salary allowance to Emmett of $42,800 2. Interest of 8% on each partner's capital balance on January 1 3. Any remaining...
-
Toya throws a ball from the top of a bridge. Her throw is modeled by the equation y=-0.5x^(2)+4x+8, and the bridge is modeled by the equation y=-0.2x+5. About how far does the ball travel...
-
Write a brief essay on Alan Turing.
-
What are the two components of a company's income tax provision? What does each component represent about a company's income tax provision?
-
There is usually no problem with the valuation of receivables because it is clear how much is legally owed to an entity. Discuss.
-
Under IAS 37, a provision for doubtful receivables is not a provision. A. True. B. False.
-
All credit balances included in a balance sheet are either capital and reserves or liabilities, actual or estimated. Discuss.
Study smarter with the SolutionInn App