please help i am wildly confused
Check my work Required information Excel Analytics 07-1 (Static) Comparing Traditional and Activity-Based Product Costing (ROI) (L07-1,7-3, 7-4, 7-5) (The following information applies to the questions displayed below.) Cary Company manufactures two models of industrial components-a Standard model and an Advanced Model. It has provided the following information with respect to these two products: Number of units produced and sold Selling price per unit Direct materials per unit Direct labor cost per unit Direct labor-hours per unit Standard 20,000 $ 150 40 $ 30 1.50 Advanced 10,000 $ 200 $ 60 $ 3e 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 Excel Analytics 07-1 (Static) Part 1 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 B11 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? Check my work WE HIVER.. Required information 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 B11 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,250 The production manager also provided the following additional information with respect to the company's two products: Machine-hours per unit Average customer order size (in units) Number of setups per customer order Number of setup hours per setup Standard 1.0 400 1 1 Advanced 2.0 50 1 3 Complete this question by entering your answers in the tabs below. View Insert Format Tools Data Window Excel File Edit Autove Home Draw Data Page Layout Insert Formulas Review View Tell me Symbol 1 Copy Forma Paste B TU a.A- A1 1 Charts a way to ease your data in order to presenting the There 1 The first step is to select the dates you would be tout en you want for your way headed and then when your com Day 2 CA SS the data challe 12 14 15 Day 1 Day? 19 204 21 Costa Cost Go to the cost Click on 1. The recommended the commended for the data set you have chosen 2. The " Alet you did the hand 25 20 27 29 On the 'Allohen 1 On the hand 2. The below that will get Charts Plantwide Approach Activity-Based Approach Activity-Based Cost View Insert Format Tools Data Window Help Auto e Insert Draw Page Layout Formulas Data Review View Tell me A ou Symbol - Coy Format A : x x A D CA Cost Go to the cost Click on within the window you have two tab "ecommended Charts and 1. The recommended Chartere you were that are have chosen 2. The "AlChartstab will let you dictate the type of chart shows all the rent chart types and as you different subtypes of charts valable for the On the "A Chat, choose the option from the 1. On the band the wine woorde 2. The below that were Double the You can in either theher Day 1.200 ving you a lotions to me the Another set of controls to in the chart and the Charter the "Cantation Activity-Based Approach Act-Based Cost Charts Partide Approach Check my work Required information Excel Analytics 07-1 (Static) Comparing Traditional and Activity-Based Product Costing (ROI) (L07-1,7-3, 7-4, 7-5) (The following information applies to the questions displayed below.) Cary Company manufactures two models of industrial components-a Standard model and an Advanced Model. It has provided the following information with respect to these two products: Number of units produced and sold Selling price per unit Direct materials per unit Direct labor cost per unit Direct labor-hours per unit Standard 20,000 $ 150 40 $ 30 1.50 Advanced 10,000 $ 200 $ 60 $ 3e 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 Excel Analytics 07-1 (Static) Part 1 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 B11 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? Check my work WE HIVER.. Required information 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 B11 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,250 The production manager also provided the following additional information with respect to the company's two products: Machine-hours per unit Average customer order size (in units) Number of setups per customer order Number of setup hours per setup Standard 1.0 400 1 1 Advanced 2.0 50 1 3 Complete this question by entering your answers in the tabs below. View Insert Format Tools Data Window Excel File Edit Autove Home Draw Data Page Layout Insert Formulas Review View Tell me Symbol 1 Copy Forma Paste B TU a.A- A1 1 Charts a way to ease your data in order to presenting the There 1 The first step is to select the dates you would be tout en you want for your way headed and then when your com Day 2 CA SS the data challe 12 14 15 Day 1 Day? 19 204 21 Costa Cost Go to the cost Click on 1. The recommended the commended for the data set you have chosen 2. The " Alet you did the hand 25 20 27 29 On the 'Allohen 1 On the hand 2. The below that will get Charts Plantwide Approach Activity-Based Approach Activity-Based Cost View Insert Format Tools Data Window Help Auto e Insert Draw Page Layout Formulas Data Review View Tell me A ou Symbol - Coy Format A : x x A D CA Cost Go to the cost Click on within the window you have two tab "ecommended Charts and 1. The recommended Chartere you were that are have chosen 2. The "AlChartstab will let you dictate the type of chart shows all the rent chart types and as you different subtypes of charts valable for the On the "A Chat, choose the option from the 1. On the band the wine woorde 2. The below that were Double the You can in either theher Day 1.200 ving you a lotions to me the Another set of controls to in the chart and the Charter the "Cantation Activity-Based Approach Act-Based Cost Charts Partide Approach
