Required information [The following information applies to the questions displayed below.] Cary Company manufactures two models...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required information [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: Standard Number of units produced and sold 20,000 Advanced 10,000 Selling price per unit 150 $ 200 Direct materials per unit 40 $ 60 Direct labor cost per unit Direct labor-hours per unit 30 1.50 $ 30 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. 5a. Go to the tab titled "Cost Allocation Comparison." Create formulas in cells B2 through C3 that compute the total overhead cost allocated to each product using the plantwide and activity-based approaches. (Hint: If you complete this step correctly, the dollar amounts shown in cells D2 and D3 should both equal $1,346,250.) 5b. How much overhead is allocated to the Standard and Advanced models using the plantwide approach (cells B2 and C2)? How much overhead is allocated to the Standard and Advanced models using the activity-based approach (cells B3 and C3)? 5c. Using Charts, create a bar chart that includes the following design elements: (1) it will include two bars pertaining to the Standard model followed by two bars pertaining to the Advanced model, (2) the first bar for each model will quantify the model's total manufacturing overhead cost according to the plantwide approach, whereas each model's second bar will quantify the model's total manufacturing overhead cost according to the activity-based approach. (Your instructor may require you to upload this file in Part 6). 5d. Based on your completed bar chart, which model is overcosted using the plantwide approach? Which model is undercosted? Complete this question by entering your answers in the tabs below. Req 5B Req 5D How much overhead is allocated to the Standard and Advanced models using the plantwide approach (cells B2 and C2)? How much overhead is allocated to the Standard and Advanced models using the activity-based approach (cells B3 and C3)? Standard Model Plantwide approach Advanced Model Activity-based approach < Req 5B Req 5D > Required information [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: Standard Number of units produced and sold 20,000 Advanced 10,000 Selling price per unit 150 $ 200 Direct materials per unit 40 $ 60 Direct labor cost per unit Direct labor-hours per unit 30 1.50 $ 30 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. 5a. Go to the tab titled "Cost Allocation Comparison." Create formulas in cells B2 through C3 that compute the total overhead cost allocated to each product using the plantwide and activity-based approaches. (Hint: If you complete this step correctly, the dollar amounts shown in cells D2 and D3 should both equal $1,346,250.) 5b. How much overhead is allocated to the Standard and Advanced models using the plantwide approach (cells B2 and C2)? How much overhead is allocated to the Standard and Advanced models using the activity-based approach (cells B3 and C3)? 5c. Using Charts, create a bar chart that includes the following design elements: (1) it will include two bars pertaining to the Standard model followed by two bars pertaining to the Advanced model, (2) the first bar for each model will quantify the model's total manufacturing overhead cost according to the plantwide approach, whereas each model's second bar will quantify the model's total manufacturing overhead cost according to the activity-based approach. (Your instructor may require you to upload this file in Part 6). 5d. Based on your completed bar chart, which model is overcosted using the plantwide approach? Which model is undercosted? Complete this question by entering your answers in the tabs below. Req 5B Req 5D How much overhead is allocated to the Standard and Advanced models using the plantwide approach (cells B2 and C2)? How much overhead is allocated to the Standard and Advanced models using the activity-based approach (cells B3 and C3)? Standard Model Plantwide approach Advanced Model Activity-based approach < Req 5B Req 5D >
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Fewer than 20% of M&M candies are green. The hypothesis test results in a P-value of 0.0721. Assume a significance level of = 0.05 a. State a conclusion about the null hypothesis. b. Without using...
-
Johnny Fuller owns and manages Johnnys Restaurant, a 24-hour restaurant near the citys medical complex. Johnny employs 9 full-time employees and 16 part-time employees. He pays all of the full-time...
-
Consider the data in Exercise 7.52. Suppose we wish to define a new inspection unit of four tape decks. (a) What are the center line and control limits for a control chart for monitoring future...
-
Which type of stock may have dividends in arrears? a. Cumulative preferred stock b. Common stock c. Noncumulative preferred stock d. Treasury stock
-
Whistler, Inc., manufactures a specialized snowboard made for the advanced snowboarder. Whistler began 2014 with an inventory of 240 snowboards. During the year, it produced 900 boards and sold 995...
-
In many data centers, this could take several weeks to purchase, install and configure a server environment just for an integrated development environment or a separate quality assurance environment....
-
Compare two individual's credibility: Think about two people - one whom you trust implicitly and another whom you do not trust. Ideally, these should be two people you currently work with or have...
-
Blood flows through the aorta at an average speed of v = 19cm/s. The aorta is roughly cylindrical with a radius r = 17.6 mm. The volume rate of blood flow through the aorta is r 2 v . Calculate the...
-
1.In theory, what should happen to the plot of your range ( y ) vs. launch angle ( x ) as the launch speed is increased? (a).Clearly state which specific points should change, and which should remain...
-
1. Within 5.0 s of lift-off, a space shuttle reaches an altitude of 525 m, uniformly accelerating during the entire time. (a) What is its acceleration? (b) At what speed is the shuttle travelling...
-
On a clear day, a person lying on a beach. If the sun rays make an angle of 45 from the vertical, what is the rate of energy absorption from the Sun by the person? Assume the surface area of the...
-
You have an object with an unknown electric charge. In other words, it could be neutral, negatively charged, or positively charged. You make two observations about this object. 1. The object of an...
-
Suppose the government introduces a new environmental regulation that significantly reduces productivity in the long run. To support the economy, the government provides a one-year corporate tax...
-
According to a recent survey, 40% of millennials (those born in the 1980s or 1990s) view themselves more as spenders than savers. The survey also reveals that 75% of millennials view social...
-
Lindesay Trading plc 1. Closing inventories are 13. 2. The following are not recorded in the trial balance: Taxation payable 58. 3. Authorised share capital was 500 for ordinary share capital and 400...
-
Superprofit Ltd. 1. Closing inventories are 26. 2. The following had not yet been recorded in the trial balance: (a) Taxation payable 13 (b) Interest on long-term loan 4 (c) Auditors fees 2 (d) The...
-
The following trial balance was extracted from the books of Leisureplay plc, a listed company, for the year ended 31 December 2012. (a) Inventories as at 31 December 2012 are 12,000 (b) Depreciation...
Study smarter with the SolutionInn App