It is December and you have just been hired as an accountant by the Sweetwater Candy...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648f11fcd9bb_3516648f11f51c06.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648f120899d2_3526648f12009ce8.jpg)
Transcribed Image Text:
It is December and you have just been hired as an accountant by the Sweetwater Candy Company operating in Fort Collins. Sweetwater is a boutique candy maker that produces only one specialty product: boxes of assorted chocolates that include a regional favorite using Colorado peaches for the filling. These chocolates have become favorites of locals and tourists. The Sweetwater Candy Company produces its chocoates at a small facility in Fort Collins Sweetwater sells each unit for $25 per box. (1 unit = 1 box of chocolates) You have been asked to get involved with the budget preparation for next year and to use the information to make decisions. The budget process is already underway, and the accounting team has worked with the sales and marketing team to develop the following sales budget for next year: $25.00 Selling price per unit Units Dollar Sales January 1,200 $30,000 February 1,000 $25,000 March 1,600 $40,000 April 1,400 $ 35,000 May 1,800 $ 45,000 June July 2,500 $ 62,500 3,500 $87,500 August 3,000 $75,000 September 2,700 $67,500 October November 2,000 $50,000 1,800 $ 45,000 December Total Annual Sales 2,500 $ 62,500 25,000 $625,000 Work through the worksheets in this Excel workbook to complete the required calculations and analyses. Provide explanations as instructed. It is now February and management is looking ahead to the summer tourist season. Sweetwater's management is considering adding a new item to its current assorted box of chocolates. The new item would be a cherry cordial (i.e., chocolate covered cherry) using Colorado cherries. Management believes that including two different chocolates from Colorado sources (peaches and cherries) will make the product more marketable to tourists. Three (3) cherry cordials would be included in each box of assorted chocolates. Management is considering whether it should produce the cherry cordials or outsource production to a local manufacturer. MAKE: BUY: If Sweetwater decides to make the cherry cordials and include 3 per box, the incremental estimated variable costs per unit (per box of chocolates) would be: Direct materials Direct labor Indirect materials (variable overhead) $0.42 $0.67 $0.80 Sweetwater would also have to purchase equipment and make some renovations to the building. These costs would add $2,000 per year of fixed costs as factory-related depreciation. Sweetwater's management believes that it will be able to reduce its cost of variable overhead after the first couple of years of producing the cherry cordials. Sweetwater would include 3 cherry cordials in each box which would allow it to remove 3 pieces of other filled chocolates from the box. Removing 3 pieces will save $1.77 in variable costs per box. Sweetwater can have a local manufacturer produce the cherry cordials using Sweetwater's recipe and production guidelines at a cost of $0.40 each (for one cherry cordial). Sweetwater will also incur an additional $1.00 of direct labor costs per box if it buys the cherry cordials because someone will have to unpack them from the manufacturer and manually put 3 pieces in each box of chocolates. Required: (A.) Prepare a make or buy analysis of costs for the cherry cordials. NOTE: Prepare the analysis for an entire year with sales of 25,000 units. (B.) How would you advise Sweetwater's management on the make-or-buy decision? Explain. It is December and you have just been hired as an accountant by the Sweetwater Candy Company operating in Fort Collins. Sweetwater is a boutique candy maker that produces only one specialty product: boxes of assorted chocolates that include a regional favorite using Colorado peaches for the filling. These chocolates have become favorites of locals and tourists. The Sweetwater Candy Company produces its chocoates at a small facility in Fort Collins Sweetwater sells each unit for $25 per box. (1 unit = 1 box of chocolates) You have been asked to get involved with the budget preparation for next year and to use the information to make decisions. The budget process is already underway, and the accounting team has worked with the sales and marketing team to develop the following sales budget for next year: $25.00 Selling price per unit Units Dollar Sales January 1,200 $30,000 February 1,000 $25,000 March 1,600 $40,000 April 1,400 $ 35,000 May 1,800 $ 45,000 June July 2,500 $ 62,500 3,500 $87,500 August 3,000 $75,000 September 2,700 $67,500 October November 2,000 $50,000 1,800 $ 45,000 December Total Annual Sales 2,500 $ 62,500 25,000 $625,000 Work through the worksheets in this Excel workbook to complete the required calculations and analyses. Provide explanations as instructed. It is now February and management is looking ahead to the summer tourist season. Sweetwater's management is considering adding a new item to its current assorted box of chocolates. The new item would be a cherry cordial (i.e., chocolate covered cherry) using Colorado cherries. Management believes that including two different chocolates from Colorado sources (peaches and cherries) will make the product more marketable to tourists. Three (3) cherry cordials would be included in each box of assorted chocolates. Management is considering whether it should produce the cherry cordials or outsource production to a local manufacturer. MAKE: BUY: If Sweetwater decides to make the cherry cordials and include 3 per box, the incremental estimated variable costs per unit (per box of chocolates) would be: Direct materials Direct labor Indirect materials (variable overhead) $0.42 $0.67 $0.80 Sweetwater would also have to purchase equipment and make some renovations to the building. These costs would add $2,000 per year of fixed costs as factory-related depreciation. Sweetwater's management believes that it will be able to reduce its cost of variable overhead after the first couple of years of producing the cherry cordials. Sweetwater would include 3 cherry cordials in each box which would allow it to remove 3 pieces of other filled chocolates from the box. Removing 3 pieces will save $1.77 in variable costs per box. Sweetwater can have a local manufacturer produce the cherry cordials using Sweetwater's recipe and production guidelines at a cost of $0.40 each (for one cherry cordial). Sweetwater will also incur an additional $1.00 of direct labor costs per box if it buys the cherry cordials because someone will have to unpack them from the manufacturer and manually put 3 pieces in each box of chocolates. Required: (A.) Prepare a make or buy analysis of costs for the cherry cordials. NOTE: Prepare the analysis for an entire year with sales of 25,000 units. (B.) How would you advise Sweetwater's management on the make-or-buy decision? Explain.
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0324645576
10th edition
Authors: W. Steve Albrecht, James D. Stice, Earl K. Stice
Posted Date:
Students also viewed these accounting questions
-
Ilana Mathers, CPA, was hired by Interactive Computer Installations to prepare its financial statements for March 2017. Using all the ledger balances in the owner's records, Ilana put together the...
-
How could a leader use attribution theory to explain the poor performance of an employee team that always seems to miss important project deadlines?
-
An electron in a three-dimensional rectangular box with dimensions of 5.00 , 3.00 , and 6.00 makes a radiative transition from the lowest-lying excited state to the ground state. Calculate the...
-
Ilectronics Inc. makes high-quality speakers for a variety of applications. Electronics Inc. is a St. Louis-based company but has significant manufacturing operations in China. When manufacturing...
-
Evergreen Company sells lawn and garden products to wholesalers. The company's fiscal year-end is December 31. During 2011, the following transactions related to receivables occurred: Feb. 28 Sold...
-
Constitutional Law Exam (Practice Questions) 1) The right to vote and stand; the Implied Freedom of Political Communication; s109 2) Commonwealth and State legislative power; s109 3) The external...
-
HW 1: Vectors (50 points) Problem 1 (10 points) For a given vectors (a), (b), (c), (d), (e) 2 points each a == 1 b:= 3 -2 Calculate (a) Summation of vectors (b) Subtraction of vectors (c)...
-
In retirement, Bill determined that he could safely invest $50,000 into a nonredeemable five-year GIC with a posted rate of 5.35% compounded semi-annually. Calculate the maturity value and the amount...
-
Shannon Company contracts to sell on September 1, 2022 equipment to a German purchaser. The price of the equipment is 200,000 and the bill will be settled in Euros. The future transaction is viewed...
-
A summary of the time tickets is as follows: Job No . Amount Job No . Amount 5 5 $ 3 , 3 0 0 Indirect $ 9 , 3 0 0 5 7 6 , 1 0 5 6 6 9 , 4 3 0 5 8 2 1 , 0 0 5 6 7 1 0 , 0 7 5 6 0 1 5 , 5 0 0...
-
At the beginning of 2025, Cullumber Construction Company changed from the cost-recovery method to recognizing revenue over time (percentage-of-completion) for financial reporting purposes. The...
-
Presented below is an aging schedule for Halleran Company at December 3 1 , 2 0 2 1 . Number of Days Past DueCustomerTotalNot Yet Due 1 - 3 0 3 1 - 6 0 6 1 - 9 0 Over 9 0 Anders$ 2 2 , 0 0 0 $ 1 0 ,...
-
Question1) When we have more s-character, the stability decreases. Could you please tell me the reason, please? Question 2) sp3-s vs sp3-sp3. Why sp3-s has more s-character than sp3-s? Could you...
-
You are the newly appointed tax practitioner to complete Emilys tax return and have downloaded the prefill report for Emilys tax return (hint, you can read what a prefill report is here (Links to an...
-
Assume that a company has in its inventory units of a particular product that were purchased at several different perunit costs. When some of these units are sold, explain how the cost of goods sold...
-
Apex Corporation operates in two locations: New York and Oregon. The LIFO method is used in accounting for inventories at the New York facility and the specific identification method is used for...
-
Assume that during the first year of Hatton Corporation's operation there were numerous purchases of identical items of merchandise. However, there was no change during the year in the prices paid...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App