{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T06:46:02-04:00", "answer_date": "2024-06-28 06:46:02", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4255131", "url": "\/study-help\/questions\/i-posted-the-whole-case-study-so-that-you-could-4255131", "question_creation_date_js": "2024-06-28T06:46:02-04:00", "question_creation_date": "Jun 28, 2024 06:46 AM", "meta_title": "[Solved] I posted the whole case study so that you | SolutionInn", "meta_description": "Answer of - I posted the whole case study so that you could refer to it. I am struggling to understand this. I figured out a lot, | SolutionInn", "meta_keywords": "posted,case,study,refer,struggling,understand,figured,lot,help,put,marks,answer", "question_title_h1": "I posted the whole case study so that you could refer to it. I am struggling to understand this. I figured out a lot, but", "question_title": "I posted the whole case study so that you could refer to", "question_title_for_js_snippet": "I posted the whole case study so that you could refer to it I am struggling to understand this I figured out a lot, but I need help to understand where I put the marks I do not want just the answer, I need to understand it, please ) Thanks so much in advance Case Scenario At Stacy's Sodas and Sliders, Stacy serves craft sodas on draft which she prepares herself Her beverage cost has always been a bit high In the past she has not addressed her excessive beverage costs because, compared to other expenses within her operation, beverage cost is relatively low and implementing inventory controls is difficult because the soda is on draft At the request of one of her investors, Stacy analyzed her beverage cost of sales over the last few months In doing so, she noticed that her costs were over 20 higher than they should have been based on her standard cost calculation This came as somewhat of a shock to Stacy she is not sure exactly what could be causing the variances As Stacy contemplated the cause of the large discrepancy between her actual beverage cost of sales and her standard beverage cost of sales, she identified some acceptable reasons the two would not match First, guests sometimes change their mind after a drink has already been poured these drinks are normally discarded Second, when a keg is first tapped or if a tap has not been used for a while, the soda supply lines will often build up foam inside which needs to be purged Third, when loading the truck each day, there are sometimes kegs with a small amount of soda in them In such cases, the soda is discarded to optimize space on the truck In Stacy's view all these reasons were acceptable, but she did not know how much of the standard cost variance was represented in this acceptable waste To find out, she asked all her staff to start pouring all discarded soda from purging the lines and voiding drinks into a bucket and log the results at the end of each shift The waste figures would then be reported in a weekly waste log report Stacy also started logging the soda that was discarded in the kitchen when loading up the truck She reasoned that the total soda recorded in her waste logs would need to be added to the amount sold to come up with a theoretical total that represented the total amount of soda that should have been used The difference between how much soda was actually used and this theoretical total is the amount of unaccounted for soda Any unaccounted for soda represents an inefficiency in her operation and an opportunity to increase Stacy's profitability There are many unacceptable reasons why there may be soda that is unaccounted for In the past, Stacy has created policies to prevent these and control her costs These policies include the following 1 Employees can only have one soda per shift served with their employee meal All employee meals, including sodas, should be recorded using the POS software 2 Complimentary drinks shall not be given to employee acquaintances or customers unless authorized by a manager Such drinks should be rang in and coded to either in store promotions or complimentary meals 3 Drinks shall not be dispensed until the sale is recorded and payment is collected 4 All drinks should be filled to from the rim (14 ounces) If followed, the measures above, along with proper waste logging, prevents any significant unaccounted for soda It is not that Stacy was indifferent about the overspending, she just figured her time was better spent focusing on controlling her food cost or labor which represent a much more significant portion of her total expenses However, she recently came across an article in a brewing publication that gave her additional insights The article stated that the true cost of unaccounted for beverages is often understated This is because standard cost variances fail to account for the potential of missing revenue For instance, assuming 100 drinks were poured, but never rang in, the product cost of those 100 drinks would be $22 57 This would cause the actual cost of beverages sold to be $22 57 higher than standard cost Looking purely at standard cost variances however potentially understates the true financial impact of 100 drinks that were poured, but never rang in If 100 drinks were poured for customers who paid for, or would have paid for, the drinks Stacy is not only out the $22 57 in product cost, but $200 00 in revenue that was never collected as well If instead, the 100 drinks were poured but never rang in because employees drank them while on shift, it is unlikely that these employees would have otherwise paid for them and thus the impact to Stacy is the $22 57 in product cost How impactful reducing the unaccounted for soda variance to zero would be is largely contingent upon how much of the variance resulted from uncollected revenue Help Stacy analyze her beverage cost of sales by calculating the following 1 The total amount of soda actually used (Question 1) 2 The total amount of soda sold (Question 2) 3 The total amount of soda that is unaccounted for (Question 3) 4 The amount of unaccounted for soda by flavor (Question 4) 5 The estimated impact of the missing soda on her profit (Question 5) Other Relevant Information A glass of soda is sold for $2 00 and contains 14 ounces A growler is a jug made of glass used to transport draft soda or beer A growler holds 64 ounces and a refill is sold for $6 00 In addition to sodas, Stacy also sells floats Customers can make any craft soda into a float with an additional charge of $2 00 On the menu and in the POS system float upgrades are recorded as Make it a float When a guest upgrades their drink to a float, approximately 6 ounces less soda is used to offset the added volume of the ice cream Soda is prepared in 25 gallon batches A batch is divided between 5 Cornelius kegs which each hold 5 gallons Kegs are stored in a designated walk in refrigerator in the kitchen where they cool and carbonate When ready for use, the kegs are loaded onto the food truck in draft dispensing units called kegerators Kegerators are keg refrigerators that have built in soda lines and taps used to pour the soda Early in the morning on the first day of the period, an inventory is taken of all items including the kegs The kegs in the walk in and on the truck are measured Soda is inventoried by the keg volumes are rounded to the nearest tenth of a keg Inventories taken at the beginning of the period are used as the ending inventory of the prior period Stacy also reports all the soda produced over the course of the period As with inventory, volumes are recorded in kegs by flavor Case Assumptions Vessel Glass Growler Make it a float Ounces 14 64 6 Sales Price $2 00 $6 00 Soda standard cost per ounce $0 016122 Conversion Chart Ounce Gallon Keg Ounce 1 0 0078125 0 0015625 Gallon 128 1 0 2 Cornelius Keg 640 5 1 Inventory Values Unit Cornelius Keg 6 18 2018 7 16 2018 8 13 2018 Black Cherry Soda 12 2 12 8 15 8 Ginger Ale 10 8 13 8 11 1 Orange Cream Soda 8 9 17 2 10 6 Root Beer 16 5 9 4 13 3 Vanilla Cream Soda 13 2 15 9 12 8 Produced 6 18 2018 7 16 2018 to to Unit Cornelius Keg 7 15 2018 8 12 2018 Black Cherry Soda 30 35 Ginger Ale 30 25 Orange Cream Soda 35 25 Root Beer 55 70 Vanilla Cream Soda 45 40 Sales Report Data Glass Sales Growler Sales Make it a Float Sales 6 18 2018 7 16 2018 6 18 2018 7 16 2018 6 18 2018 7 16 2018 to to to to to to 7 15 2018 8 12 2018 7 15 2018 8 12 2018 7 15 2018 8 12 2018 Black Cherry Soda 826 857 71 85 972 1015 Ginger Ale 685 705 67 70 Orange Cream Soda 750 818 68 86 Root Beer 1784 1852 171 190 Vanilla Cream Soda 1005 1013 117 127 Weekly Waste Logs 6 18 2018 6 25 2018 7 2 2018 7 9 2018 7 16 2018 7 23 2018 7 30 2018 8 6 2018 to to to to to to to to Department 6 24 2018 7 1 2018 7 8 2018 7 15 2018 7 22 2018 7 29 2018 8 5 2018 8 12 2018 Kitchen (gallons) 4 9 3 2 1 4 1 3 3 5 2 2 4 3 Truck 3 1 5 6 5 1 7 8 3 6 7 9 9 1 4 8 Total 8 8 6 7 2 11 9 6 9 12 9 11 3 9 1 Question 1 Calculate the ACTUAL usage in Cornelius kegs and gallons from 6 18 to 7 15 Beginning Produced Ending Actual Actual Unit Cornelius Keg Inventory Inventory Gallons Black Cherry Soda 12 2 30 42 2 42 2 8 44 Ginger Ale 10 8 30 40 8 40 8 8 16 Orange Cream Soda 8 9 35 43 9 43 9 8 78 Root Beer 16 5 55 71 5 71 5 14 3 Vanilla Cream Soda 13 2 45 58 2 58 2 11 64 Total 61 6 195 256 6 256 6 51 32 Question 2 Calculate the ounces and gallons SOLD from 6 18 to 7 15 Glasses (Ounces) Growlers (Ounces) Total (Ounces) Total (Gallons) Black Cherry Soda 11564 4544 16108 125 84375 Ginger Ale 9590 4288 13878 108 421875 Orange Cream Soda 10500 4352 14852 116 03125 Root Beer 24976 10944 35920 280 625 Vanilla Cream Soda 14070 7488 21558 168 421875 Make it a float 5832 0 5832 45 5625 Total 64868 31616 96484 753 78125 Question 3 Determine the amount of soda that is unaccounted for from 6 18 to 7 15 Category Gallons Total Actual Use Recorded Soda Waste Sold Theoretical Total (waste sold) Unaccounted for soda Unaccounted for soda (divide by theo total) Question 4 Determine the unaccounted for soda variance for each soda from 6 18 to 7 15 Actual Sold Variance Variance Black Cherry Soda 147 125 84375 21 15625 Ginger Ale 135 108 421875 26 578125 Orange Cream Soda 133 5 116 03125 17 46875 Root Beer 310 5 280 625 29 875 Vanilla Cream Soda 211 5 168 421875 43 078125 Question 5 The root cause of the unaccounted for soda is unclear Calculate the impact to Stacy's Sodas and Sliders for three scenarios from 6 18 to 7 15 In scenario 1, assume that all of the unaccounted for soda is due to product related costs In scenario 2, assume that half the unaccounted for soda is due to product related costs and the other half is due to uncollected revenue In scenario 3, assume that all the unaccounted soda is due to uncollected revenue Scenario 1 Scenario 2 Scenario 3 Unaccounted for soda (ounces) Portion resulting in lost revenue ( ) 0 00 50 00 100 00 Portion resulting in lost revenue (oz) Portion resulting in lost revenue (glasses) Lost Revenue Portion not resulting in lost revenue ( ) 100 50 0 Portion not resulting in lost revenue (oz) Soda standard cost per ounce Cost of portion not resulting in lost revenue Total cost of unaccounted for soda This is the expected increase in profit if the unaccounted for soda variance was brought to zero In cases where revenue is missing, revenue would be recorded In cases where revenue would not likely would have been generated, costs are brought to zero ", "question_description": "

I posted the whole case study so that you could refer to it. I am struggling to understand this. I figured out a lot, but I need help to understand where I put the ? marks. I do not want just the answer, I need to understand it, please :) Thanks so much in advance!<\/p>

Case Scenario<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
At Stacy's Sodas and Sliders, Stacy serves craft sodas on draft which she prepares herself. Her beverage cost has always been a bit high. In the past she has not addressed her excessive beverage costs because, compared to other expenses within her operation, beverage cost is relatively low and implementing inventory controls is difficult because the soda is on draft. At the request of one of her investors, Stacy analyzed her beverage cost of sales over the last few months. In doing so, she noticed that her costs were over 20% higher than they should have been based on her standard cost calculation. This came as somewhat of a shock to Stacy; she is not sure exactly what could be causing the variances.<\/td><\/tr>
As Stacy contemplated the cause of the large discrepancy between her actual beverage cost of sales and her standard beverage cost of sales, she identified some acceptable<\/u> reasons the two would not match. First, guests sometimes change their mind after a drink has already been poured; these drinks are normally discarded. Second, when a keg is first tapped or if a tap has not been used for a while, the soda supply lines will often build up foam inside which needs to be purged. Third, when loading the truck each day, there are sometimes kegs with a small amount of soda in them. In such cases, the soda is discarded to optimize space on the truck. In Stacy's view all these reasons were acceptable, but she did not know how much of the standard cost variance was represented in this acceptable waste. To find out, she asked all her staff to start pouring all discarded soda from purging the lines and voiding drinks into a bucket and log the results at the end of each shift. The waste figures would then be reported in a weekly waste log report. Stacy also started logging the soda that was discarded in the kitchen when loading up the truck. She reasoned that the total soda recorded in her waste logs would need to be added to the amount sold to come up with a theoretical total that represented the total amount of soda that should have been used. The difference between how much soda was actually used and this theoretical total is the amount of unaccounted for soda.<\/td><\/tr>
Any unaccounted for soda represents an inefficiency in her operation and an opportunity to increase Stacy's profitability. There are many unacceptable<\/u> reasons why there may be soda that is unaccounted for. In the past, Stacy has created policies to prevent these and control her costs. These policies include the following: 1. Employees can only have one soda per shift served with their employee meal. All employee meals, including sodas, should be recorded using the POS software. 2. Complimentary drinks shall not be given to employee acquaintances or customers unless authorized by a manager. Such drinks should be rang in and coded to either in-store promotions or complimentary meals. 3. Drinks shall not be dispensed until the sale is recorded and payment is collected 4. All drinks should be filled to \" from the rim (14 ounces) If followed, the measures above, along with proper waste logging, prevents any significant unaccounted for soda.<\/td><\/tr>
It is not that Stacy was indifferent about the overspending, she just figured her time was better spent focusing on controlling her food cost or labor which represent a much more significant portion of her total expenses. However, she recently came across an article in a brewing publication that gave her additional insights. The article stated that the true cost of unaccounted for beverages is often understated. This is because standard cost variances fail to account for the potential of missing revenue. For instance, assuming 100 drinks were poured, but never rang in, the product cost of those 100 drinks would be $22.57. This would cause the actual cost of beverages sold to be $22.57 higher than standard cost. Looking purely at standard cost variances however potentially understates the true financial impact of 100 drinks that were poured, but never rang in. If 100 drinks were poured for customers who paid for, or would have paid for, the drinks; Stacy is not only out the $22.57 in product cost, but $200.00 in revenue that was never collected as well! If instead, the 100 drinks were poured but never rang in because employees drank them while on shift, it is unlikely that these employees would have otherwise paid for them and thus the impact to Stacy is the $22.57 in product cost. How impactful reducing the unaccounted for soda variance to zero would be is largely contingent upon how much of the variance resulted from uncollected revenue.<\/td><\/tr>
Help Stacy analyze her beverage cost of sales by calculating the following: 1. The total amount of soda actually used (Question 1) 2. The total amount of soda sold (Question 2) 3. The total amount of soda that is unaccounted for (Question 3) 4. The amount of unaccounted for soda by flavor (Question 4) 5. The estimated impact of the missing soda on her profit (Question 5)<\/td><\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Other Relevant Information<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
A glass of soda is sold for $2.00 and contains 14 ounces. A growler is a jug made of glass used to transport draft soda or beer. A growler holds 64 ounces and a refill is sold for $6.00. In addition to sodas, Stacy also sells floats. Customers can make any craft soda into a float with an additional charge of $2.00. On the menu and in the POS system float upgrades are recorded as \"Make-it-a-float\". When a guest upgrades their drink to a float, approximately 6 ounces less soda is used to offset the added volume of the ice cream. Soda is prepared in 25 gallon batches. A batch is divided between 5 Cornelius kegs which each hold 5 gallons. Kegs are stored in a designated walk-in refrigerator in the kitchen where they cool and carbonate. When ready for use, the kegs are loaded onto the food truck in draft dispensing units called kegerators. Kegerators are keg refrigerators that have built-in soda lines and taps used to pour the soda. Early in the morning on the first day of the period, an inventory is taken of all items including the kegs. The kegs in the walk-in and on the truck are measured. Soda is inventoried by the keg; volumes are rounded to the nearest tenth of a keg. Inventories taken at the beginning of the period are used as the ending inventory of the prior period. Stacy also reports all the soda produced over the course of the period. As with inventory, volumes are recorded in kegs by flavor.<\/td><\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Case Assumptions<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vessel<\/td> Glass<\/td> Growler<\/td> Make it a float<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ounces<\/td> 14<\/td> 64<\/td> -6<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Sales Price<\/td> $2.00<\/td> $6.00<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Soda standard cost per ounce<\/td> $0.016122<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Conversion Chart<\/strong><\/td> Ounce<\/td> Gallon<\/td> Keg<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ounce<\/td> 1<\/td> 0.0078125<\/td> 0.0015625<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Gallon<\/td> 128<\/td> 1<\/td> 0.2<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Cornelius Keg<\/td> 640<\/td> 5<\/td> 1<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Inventory Values<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Unit: Cornelius Keg<\/td> 6\/18\/2018<\/td> 7\/16\/2018<\/td> 8\/13\/2018<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 12.2<\/td> 12.8<\/td> 15.8<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ginger Ale<\/td> 10.8<\/td> 13.8<\/td> 11.1<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 8.9<\/td> 17.2<\/td> 10.6<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 16.5<\/td> 9.4<\/td> 13.3<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 13.2<\/td> 15.9<\/td> 12.8<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Produced<\/strong><\/td> 6\/18\/2018<\/td> 7\/16\/2018<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> to<\/td> to<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Unit: Cornelius Keg<\/td> 7\/15\/2018<\/td> 8\/12\/2018<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 30<\/td> 35<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ginger Ale<\/td> 30<\/td> 25<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 35<\/td> 25<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 55<\/td> 70<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 45<\/td> 40<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Sales Report Data<\/strong><\/td> Glass Sales<\/td> Growler Sales<\/td> <\/td> Make-it-a-Float Sales<\/td> <\/td> <\/tr>
<\/td> 6\/18\/2018<\/td> 7\/16\/2018<\/td> 6\/18\/2018<\/td> 7\/16\/2018<\/td> <\/td> 6\/18\/2018<\/td> 7\/16\/2018<\/td> <\/td> <\/tr>
<\/td> to<\/td> to<\/td> to<\/td> to<\/td> <\/td> to<\/td> to<\/td> <\/td> <\/tr>
<\/td> 7\/15\/2018<\/td> 8\/12\/2018<\/td> 7\/15\/2018<\/td> 8\/12\/2018<\/td> <\/td> 7\/15\/2018<\/td> 8\/12\/2018<\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 826<\/td> 857<\/td> 71<\/td> 85<\/td> <\/td> 972<\/td> 1015<\/td> <\/td> <\/tr>
Ginger Ale<\/td> 685<\/td> 705<\/td> 67<\/td> 70<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 750<\/td> 818<\/td> 68<\/td> 86<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 1784<\/td> 1852<\/td> 171<\/td> 190<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 1005<\/td> 1013<\/td> 117<\/td> 127<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Weekly Waste Logs<\/strong><\/td> 6\/18\/2018<\/td> 6\/25\/2018<\/td> 7\/2\/2018<\/td> 7\/9\/2018<\/td> 7\/16\/2018<\/td> 7\/23\/2018<\/td> 7\/30\/2018<\/td> 8\/6\/2018<\/td> <\/tr>
<\/td> to<\/td> to<\/td> to<\/td> to<\/td> to<\/td> to<\/td> to<\/td> to<\/td> <\/tr>
Department<\/td> 6\/24\/2018<\/td> 7\/1\/2018<\/td> 7\/8\/2018<\/td> 7\/15\/2018<\/td> 7\/22\/2018<\/td> 7\/29\/2018<\/td> 8\/5\/2018<\/td> 8\/12\/2018<\/td> <\/tr>
Kitchen (gallons)<\/em> <\/td> 4.9<\/td> 3<\/td> 2.1<\/td> 4.1<\/td> 3.3<\/td> 5<\/td> 2.2<\/td> 4.3<\/td> <\/tr>
Truck<\/td> 3.1<\/td> 5.6<\/td> 5.1<\/td> 7.8<\/td> 3.6<\/td> 7.9<\/td> 9.1<\/td> 4.8<\/td> <\/tr>
Total<\/td> 8<\/td> 8.6<\/td> 7.2<\/td> 11.9<\/td> 6.9<\/td> 12.9<\/td> 11.3<\/td> 9.1<\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Question 1: Calculate the ACTUAL<\/u> usage in Cornelius kegs and gallons from 6\/18 to 7\/15<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> Beginning<\/td> Produced<\/td> Ending<\/td> Actual<\/td> Actual<\/td> <\/td> <\/td> <\/td> <\/tr>
Unit: Cornelius Keg<\/em><\/td> Inventory<\/td> Inventory<\/td> Gallons<\/td> <\/td> <\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 12.2<\/td> 30<\/td> 42.2<\/td> 42.2<\/td> 8.44<\/td> <\/td> <\/td> <\/td> <\/tr>
Ginger Ale<\/td> 10.8<\/td> 30<\/td> 40.8<\/td> 40.8<\/td> 8.16<\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 8.9<\/td> 35<\/td> 43.9<\/td> 43.9<\/td> 8.78<\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 16.5<\/td> 55<\/td> 71.5<\/td> 71.5<\/td> 14.3<\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 13.2<\/td> 45<\/td> 58.2<\/td> 58.2<\/td> 11.64<\/td> <\/td> <\/td> <\/td> <\/tr>
Total<\/td> 61.6<\/td> 195<\/td> 256.6<\/td> 256.6<\/td> 51.32<\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Question 2: Calculate the ounces and gallons SOLD<\/u> from 6\/18 to 7\/15<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> Glasses (Ounces)<\/td> Growlers (Ounces)<\/td> Total (Ounces)<\/td> Total (Gallons)<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 11564<\/td> 4544<\/td> 16108<\/td> 125.84375<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ginger Ale<\/td> 9590<\/td> 4288<\/td> 13878<\/td> 108.421875<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 10500<\/td> 4352<\/td> 14852<\/td> 116.03125<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 24976<\/td> 10944<\/td> 35920<\/td> 280.625<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 14070<\/td> 7488<\/td> 21558<\/td> 168.421875<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Make it a float<\/td> -5832<\/td> 0<\/td> -5832<\/td> -45.5625<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Total<\/td> 64868<\/td> 31616<\/td> 96484<\/td> 753.78125<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Question 3: Determine the amount of soda that is unaccounted for from 6\/18 to 7\/15<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Category<\/td> Gallons<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Total Actual Use<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Recorded Soda Waste<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Sold<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Theoretical Total (waste + sold)<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Unaccounted for soda<\/td>

?<\/p>

<\/p> <\/td>

<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Unaccounted for soda % (divide by theo total)<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Question 4: Determine the unaccounted for soda variance for each soda from 6\/18 to 7\/15<\/strong><\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> Actual<\/td> Sold<\/td> Variance<\/td> Variance %<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Black Cherry Soda<\/td> 147<\/td> 125.84375<\/td> 21.15625<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Ginger Ale<\/td> 135<\/td> 108.421875<\/td> 26.578125<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Orange Cream Soda<\/td> 133.5<\/td> 116.03125<\/td> 17.46875<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Root Beer<\/td> 310.5<\/td> 280.625<\/td> 29.875<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Vanilla Cream Soda<\/td> 211.5<\/td> 168.421875<\/td> 43.078125<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Question 5: <\/strong>The root cause of the unaccounted for soda is unclear. Calculate the impact to Stacy's Sodas and Sliders for three scenarios from 6\/18 to 7\/15. <\/strong>In scenario 1, assume that all of the unaccounted for soda is due to product related costs. In scenario 2, assume that half the unaccounted for soda is due to product related costs and the other half is due to uncollected revenue. In scenario 3, assume that all the unaccounted soda is due to uncollected revenue.<\/td><\/tr>
<\/td> Scenario 1<\/td> Scenario 2<\/td> Scenario 3<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Unaccounted for soda (ounces)<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Portion resulting in lost revenue (%)<\/td> 0.00%<\/td> 50.00%<\/td> 100.00%<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Portion resulting in lost revenue (oz)<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Portion resulting in lost revenue (glasses)<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Lost Revenue<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Portion not resulting in lost revenue (%)<\/td> 100%<\/td> 50%<\/td> 0%<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Portion not resulting in lost revenue (oz)<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Soda standard cost per ounce<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Cost of portion not resulting in lost revenue<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
Total cost of unaccounted for soda*<\/td> ?<\/td> ?<\/td> ?<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr>
* This is the expected increase in profit if the unaccounted for soda variance was brought to zero. In cases where revenue is missing, revenue would be recorded. In cases where revenue would not likely would have been generated, costs are brought to zero.<\/td><\/tr>
<\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/td> <\/tr> <\/tbody><\/table><\/figure>", "transcribed_text": "", "related_book": { "title": "Auditing Cases An Active Learning Approach", "isbn": "0130674842, 978-0130674845", "edition": "2nd Edition", "authors": "Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/64ed8a8041add_6938.jpg", "uri": "\/textbooks\/abnormal-psychology-clinical-perspectives-on-psychological-disorders-1st-edition-9781266566899", "see_more_uri": "" }, "free_related_book": { "isbn": "0415544777", "uri": "\/textbooks\/economic-theory-and-sustainable-development-what-can-we-preserve-for-future-generations-1st-edition-978-0415544771-278744", "name": "Economic Theory And Sustainable Development What Can We Preserve For Future Generations", "edition": "1st Edition" }, "question_posted": "2024-06-28 06:46:02", "see_more_questions_link": "\/study-help\/questions\/business-finance-2024-September-13", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/museum-clinic-has-been-under-pressure-to-keep-costs-down", "description": "Museum Clinic has been under pressure to keep costs down. The clinic administrator has been managing various revenue-producing centers to maximize contributions to the recovery of the operating costs...", "stars": 3 }, { "url": "\/study-help\/psychology\/3-tell-us-how-you-reached-that-conclusion-what-steps-1984314", "description": "3. Tell us how you reached that conclusion. What steps did you go through?", "stars": 3 }, { "url": "\/the-2013-income-statement-of-anderson-medical-supply-company-reported", "description": "The 2013 income statement of Anderson Medical Supply Company reported net sales of $8 million, cost of goods sold of $4.8 million, and net income of $800,000. The following table shows the companys...", "stars": 3 }, { "url": "\/study-help\/questions\/mother-nature-supplies-following-are-selected-data-from-the-financial-9862556", "description": "Mother Nature Supplies Following are selected data from the financial statements of Mother Nature Supplies: Refer to the data for Mother Nature Supplies. Which of the following results would be found...", "stars": 3 }, { "url": "\/study-help\/questions\/1113-a-sr100000-is-invested-into-a-fund-pays-an-9295890", "description": "11-13) A SR100,000 is invested into a fund pays an interest of 12.12%\/year\/quarter in order to make 36 monthly withdrawals. Each withdrawal decreased by 2% from the previous one and the first...", "stars": 3 }, { "url": "\/study-help\/questions\/you-purchased-merchandise-from-a-suppler-and-failed-to-pay-482113\/1000", "description": "Joe has designed a new smart water filter for industrial applications. Joe calls the water filter the \"SMARTY SIEVE\". The filter has a novel 3-dimensional shape. Joe asks a Mary to design a logo for...", "stars": 3 }, { "url": "\/study-help\/questions\/the-interview-is-not-the-final-stage-of-the-employment-1004901", "description": "The interview is not the final stage of the employment process. Background checks are frequently conducted to verify the information provided by applicants on their rsums and application forms and...", "stars": 3 }, { "url": "\/study-help\/questions\/question-4-a-study-the-following-balanced-scorecard-diagram-financial-1004992", "description": "QUESTION 4 (a) Study the following balanced scorecard diagram: Financial perspective Customer perspective Learning and Internal growth perspective processes perspective Analyze how balanced scorecard...", "stars": 3 }, { "url": "\/study-help\/questions\/1-production-and-inventory-management-simulation-problem-neo-ev-1005113", "description": "1. Production and Inventory Management - Simulation Problem Neo EV is an electrical bus manufacturer headquartered in California. Based on historical sales data and committed contracts, the forecast...", "stars": 3 }, { "url": "\/study-help\/questions\/read-the-article-why-firms-go-green-schumpeter-2011-then-1005467", "description": "Read the article Why Firms Go Green, Schumpeter, 2011, then: a) What type of single stories do you think internal stakeholders of a company may have in regards to Green initiatives? b) What role do...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/question-3-20-marks-solar-energy-inc-issued-a-900000-4255130", "next": "\/study-help\/questions\/on-january-1-2019-camil-company-entered-into-a-lease-4255132" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "I posted the whole case study so that you could refer to", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/i-posted-the-whole-case-study-so-that-you-could-4255131" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }1" } }