Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required information (The following information applies to the questions displayed below) Cary Company manufactures two models of industrial components - Standard model and an Advanced

image text in transcribed
image text in transcribed
image text in transcribed
Required information (The following information applies to the questions displayed below) Cary Company manufactures two models of industrial components - Standard model and an Advanced Model. It has provided the following information with respect to these two products: Standard Advanced Number of units produced and sold 20,000 10,888 Selling price per unit 150 $ 200 Direct materials per unit $ 40 $ 60 Direct labor cost per unit $ 30 30 Direct labor-hours per unit 1.50 1.50 $ The company considers all of its manufacturing overhead costs ($1,346,250) to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor hours. Click here to download the Excel template, which you will use to answer the questions that follow Click here for a a brief tutorial on Charts in Excel Required: 1. Go to the tab titled "Plantwide Approach a. Create a formula that calculates the direct labor-hours in the denominator of the plantwide overhead rate (cell F3). Also, create a formula that calculates the plantwide overhead rate (cell F4). What formulas correctly calculate these two amounts? b. What is the plantwide overhead rate? c. Create the appropriate formulas (within cells 811 through D17) to compute the gross margins for the Standard and Advanced models as well as the company as a whole. What formulas correctly calculate the direct materials, direct labor, and manufacturing overhead for the Standard model? d. What are the gross margins for the Standard model (cell B17) and the Advanced model (cell C17)? e. Using Charts, create a pie chart that shows the percent of total manufacturing overhead cost allocated to each product using the plantwide approach. (Your instructor may require you to upload this file in Part 6). f. What percent of the total manufacturing overhead cost is allocated to the Standard model using the plantwide approach? The Advanced model? Cary's production manager has suggested replacing the company's current cost system with an activity-based costing system that assigns all of the company's manufacturing overhead costs to four activity cost pools as follows the company does not have any organization-sustaining costs or unused capacity costs Manufacturing Activity Measure Activity Measure Overhead Assemble and pack Direct labor hours $ 292,500 Machining Machine-hours 440,000 Order processing Number of customer orders 256,250 Setups Setup hours 357,500 $1,346,25e The production manager also provided the following additional information with respect to the company's two products Standard Advanced Machine-hours per unit Average customer order size 1.8 2.0 (in units) 400 50 Number of setups per customer order 1 1 Number of setup hours per 1 setup 3 Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Req 10 Req 10 Req 1F What is the plantwide overhead rate? (Round your answer to 2 decimal places.) Plantwide overhead per direct labor-hour mate Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 10 Req 1D Req 1F What are the gross margins for the Standard model (cell B17) and the Advanced model (cell C17)? Standard Advanced Model Model Gross margin

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

Auditors Guide To Information Systems Auditing

Authors: Richard E. Cascarino

1st Edition

0470009896, 978-0470009895

More Books

Students also viewed these Accounting questions

Question

What is Larmors formula? Explain with a suitable example.

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago