Glaze is a regional ice cream chain in the Midwest that produces its own ice cream....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Glaze is a regional ice cream chain in the Midwest that produces its own ice cream. Glaze creates high-quality, premium ice cream. They produce classic ice cream flavors (like vanilla and chocolate) as well as some exotic ice cream flavors like "Polynesian Fantasy" or "Mango Lemon Supreme". Glaze began as a small operation, founded by Claire Bosley. As Glaze grew, Claire decided to rent a building for production and has since been able to afford more expensive, automated manufacturing equipment. Glaze's most significant production costs are for the raw materials (like cream or sugar) and for the operation and maintenance of the production equipment. All of Glaze's products are sold at the same retail price, which is approximately a markup of 100% on production costs. Currently, Claire uses the plantwide allocation method to estimate product costs of each ice cream. Her plantwide manufacturing overhead rate is 200% of direct labor costs (i.e. $2/DLS). Although Claire is an expert in ice cream, she has much less experience in accounting. Claire hired you to take a look at her current costing system to make sure she was pricing her product well. Claire prepared a few exhibits for you to use in your analysis (found in the excel spreadsheet). In Exhibit 1, Claire lists out the budgeted manufacturing overhead costs. In Exhibit 2, Claire provides detailed information on the production of the "Polynesian Fantasy" and "Vanilla" flavors. Download the case template from Blackboard to get started. Throughout the assignment, use excel formulas that reference the exhibits instead of hard-coding values. 1. In the PINK cells, Calculate the cost per gallon of Polynesian Fantasy and Vanilla using the plantwide allocation method using the MOH rate of 200% of direct labor costs (i.c. $2/DLS). 2. Next, calculate the cost per gallon of Polynesian Fantasy and Vanilla using the activity- based costing method. See hints provided in the spreadsheet. a. Step 1: First compute the MOH Rates for each activity in the YELLOW cells. b. Step 2: Compute the Actual Basis Used in the PURPLE cells. See the hints provided in the template. c. Step 3: Using your computations in steps 1 and 2, calculate the MOH Allocated for each activity and the Total Cost per Gallon in the BLUE cells. 3. Lastly, evaluate your findings in the textbox provided. Should Claire switch from the plantwide allocation method to the activity-based costing method? Why or why not? **Make sure all team member's names are in your file** **Submit your completed assignment on Blackboard** Glaze is a regional ice cream chain in the Midwest that produces its own ice cream. Glaze creates high-quality, premium ice cream. They produce classic ice cream flavors (like vanilla and chocolate) as well as some exotic ice cream flavors like "Polynesian Fantasy" or "Mango Lemon Supreme". Glaze began as a small operation, founded by Claire Bosley. As Glaze grew, Claire decided to rent a building for production and has since been able to afford more expensive, automated manufacturing equipment. Glaze's most significant production costs are for the raw materials (like cream or sugar) and for the operation and maintenance of the production equipment. All of Glaze's products are sold at the same retail price, which is approximately a markup of 100% on production costs. Currently, Claire uses the plantwide allocation method to estimate product costs of each ice cream. Her plantwide manufacturing overhead rate is 200% of direct labor costs (i.e. $2/DLS). Although Claire is an expert in ice cream, she has much less experience in accounting. Claire hired you to take a look at her current costing system to make sure she was pricing her product well. Claire prepared a few exhibits for you to use in your analysis (found in the excel spreadsheet). In Exhibit 1, Claire lists out the budgeted manufacturing overhead costs. In Exhibit 2, Claire provides detailed information on the production of the "Polynesian Fantasy" and "Vanilla" flavors. Download the case template from Blackboard to get started. Throughout the assignment, use excel formulas that reference the exhibits instead of hard-coding values. 1. In the PINK cells, Calculate the cost per gallon of Polynesian Fantasy and Vanilla using the plantwide allocation method using the MOH rate of 200% of direct labor costs (i.c. $2/DLS). 2. Next, calculate the cost per gallon of Polynesian Fantasy and Vanilla using the activity- based costing method. See hints provided in the spreadsheet. a. Step 1: First compute the MOH Rates for each activity in the YELLOW cells. b. Step 2: Compute the Actual Basis Used in the PURPLE cells. See the hints provided in the template. c. Step 3: Using your computations in steps 1 and 2, calculate the MOH Allocated for each activity and the Total Cost per Gallon in the BLUE cells. 3. Lastly, evaluate your findings in the textbox provided. Should Claire switch from the plantwide allocation method to the activity-based costing method? Why or why not? **Make sure all team member's names are in your file** **Submit your completed assignment on Blackboard**
Expert Answer:
Answer rating: 100% (QA)
Lastly evaluate your findings in the textbox provided Should Claire switch from the plantwide alloca... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these accounting questions
-
Main Street Ice Cream Company uses a plantwide allocation method to allocate overhead based on direct labor-hours at a rate of $3 per labor-hour. Strawberry and vanilla flavors are produced in...
-
Main Street Ice Cream Company uses a plantwide allocation method to allocate overhead based on direct labor-hours at a rate of $2 per labor-hour. Strawberry and vanilla flavors are produced in...
-
Kipling Manufacturing, Inc., operates a plant that produces its own regionally-marketed Super Salad Dressing. The dressing is produced in two processes, blending and bottling. In the Blending...
-
The figure shows the result of taking 25 SRSs from a Normal population and constructing a confidence interval for the population mean using each sample. Which confidence level 80%, 90%, 95%, or 99%do...
-
In advertising, what is meant by ROI?
-
On January 1, 2020, McIlroy, Inc., acquired a 60 percent interest in the common stock of Stinson, Inc., for $372,000. Stinsons book value on that date consisted of common stock of $100,000 and...
-
A pension fund has just paid some of its liabilities, and as a result of this transaction the fund is no longer fully immunized. The fund manager decides that instead of changing the portfolio, the...
-
Presented here are an incomplete income statement and balance sheet for Schwenke Corporation. Additional information: 1. The gross profit margin is 40%. 2. The income tax rate is 20%. 3. The...
-
At the end of May, the sales journal of Mountain View appears as follows. Assume beginning inventory balance for May to be $8,572. Sales Journal Accounts Receivable Debit Invoice Date May 6 Account...
-
Suppose you have a list of blood platelet counts from 500 patients in a hospital. Which of the following is most helpful in understanding the distribution of those values: frequency table, pie chart,...
-
Using the data in the table: a. What was the average annual return of Microsoft stock from 2005-2017? b. What was the annual volatility for Microsoft stock from 2005-2017? Question content area...
-
Define an appropriate sample space for each of the experiments described below: a. At the close of business each day, the Acme Department Store's accountant counts the number of customer transactions...
-
Which of the following are examples of maturity transformations? Which are subject to a bank-run-like phenomenon in which fear of a failure becomes a selffulfilling prophecy? Explain. a. You sell...
-
Describe the incentive problem facing the U.S. government in responding to the 20072009 crisis with respect to the shadow banking sector. How did the Dodd- Frank bill attempt to address those...
-
Pharmacists may become licensed in all states by simply transferring their license from another state. This process of license transfer, known as either reciprocity or endorsement in most states, is...
-
Jen Company decided to change its method of accounting from the cash basis to the accrual basis in 2018. Its taxable income for 2018 under the accrual basis was \(\$ 250,000\). It determined that the...
-
You have won big at the lottery! You want to share some of this windfall with a school for disadvantaged students. Find the amount which you would have to invest now, at an annual compound rate of...
-
Fahrad Inc. sells all of its product on account. Fahrad has the following accounts receivable payment experience: Percent paid in the month of sale .........10 Percent paid in the month after the...
-
A young couple, Eve and Steven, want to divide their main household chores (marketing, cooking, dishwashing, and laundering) between them so that each has two tasks but the total time they spend on...
-
You are given the following payoff table. a. Assume that your utility function for the payoffs is U(x) (x. Plot the expected utility of each decision alternative versus the value of p on the same...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 6.4. Briefly describe how network optimization models...
-
Continue with the case of Hindustan Lever Ltd. Analyse the news items to predict the future outlook of the company and to strategise its improvement. Attempt the following requirements towards this...
-
Form a small group. Concentrate on BSE Sensex companies and compile the voluntary disclosures made by each of them. Draft a crisp research paper highlighting your findings and use thereof to various...
-
Hassan Abu-Jihaad was convicted of disclosing national defense information and of providing material support to terrorist by a jury in the District Court of Connecticut. Abu-Jihaad moved for a...
IES 2012 Mechanical Engineering Objective Solved Paper II 1st Edition - ISBN: 9381069875 - Free Book
Study smarter with the SolutionInn App