Category G Instructions Complete the yellow-shaded cells. Category Direct Labor Bottling labor Boxing & Crating labor Crush tabor Harvest labor cost $ 21,000 $ 4,200 5,200 $ 125,000 Fixed Product Overhead Production Salary Depreciation Lab Fees Wine mister te Waste treatment cost $ 75.000 5 54,000 $ 15,000 $ 30,000 s 2,000 $ 155,400 $ 175,000 Account balance Account ut Dec 31, 2018 Administrative Office Rent 5 24,000 Administrative salaries 5 175.000 Bottle, labels, corks S 35,240 Botting labor 5 21.000 Boxing & Crating labor 5 4,200 BORES 12,550 Crush labor 5,200 Depreciation $ 54,000 Fermenting ingredients 15,520 Grapes 203,250 Harvestata 125.000 Lab fees $ 15,000 Production Supervisor salary 75,000 Recycled Scrap rapes 3.080 Sales commissions $ 35.000 Sales manager salary 5 85.000 Utilities - fermenting process 5 5.470 Waste treatment $ 2,000 Wine master fee 5 30,000 Check qure total 2010 Variable SIA Sales Commision 35,000 Direct Materials Bottles, labels, corks boxes rernenting ingredients Grapes cost 5 35,240 $ 12,550 3 15.520 $ 205,250 35.000 200,560 Fixed SORA Administrative Office Rent Administrative salaries Sales mariner salary cost 24,000 $175,000 85,000 Variable Product Overhead Utilities Recycles Scrap rapes cost S $ 5.470 3,080 $ 284,000 Check figure total 5925,510 8.550 Formatting Clipboard Font Alignment Number 15 A B D E G H Relevant Costs for Decision-Making Instructions complete the yellow shaded cells. Product to Drop: $ Remaining After Drop Increase (Decrease) Estate Blend Table Total $ S S US 6 7 8 9 10 Sales Total Variable costs Contribution Margin Total Fixed Costs Net Income (before Taxes) $ S s $ $ $ 11 12 should one of the wines be Dropped from the Product Mix? Please Explain your reasoning 13 14 15 16 17 18 19 20 21 Number B11 F G A B c D E 1 Instructions: Complete the yellow-shaded cells. 2 Constrained resources: Plant Capacity, Projected Demand and pounds of grapes available 3 Estate Blend Table 4 5 Lbs of Cabernet grape per bottle 6 Lbs of Generic grape per bottle 7 Total lbs of grapes per bottle 8 0 10 #bottles to lbs of Cabernet lbs of Generic produce grapes needed grapes needed 12 13 14 Estate Blend Table 15 Excess or (Shortage) in Ibs 16 Pounds of Cabernet grapes 17 purchased Pounds of Generic grapes 18 purchased 19 20 21 ull 2:58 Submission Term Project Part 1: Current Financial Pos... Nov 19, 2020 at 8:41 AM Relevant Cost for Decision Making som Cat . role of the brother Murering In Chew shaded Constrained curtes Plant Capacky Projected Demand and pound possible Estate Blend Los e Cabemet peper bottle Lbs of Generic grape per borte Toate apes per te horties to this of Cabernet be of Generic produce grapes needed papes meded Este Blend Table E Pounds of Cabernet grapes purchased Pound of Generic grapes purchased Sales Budget for Year Ended Dec 31, 2015 Direct Material Budget Physical Units Bulipes Ger www Comments Files (1) Rubric D Dashboard Calendar To Do Notifications Inbox 2:58 Submission Term Project Part 1: Current Financial Posi... Nov 19, 2020 at 8:41 AM Sales Budget for Year Ended 2015 Catate Direct Material Budget Physical Units Buget Gm Cont Budget La Bret Materiais Grer that en Cole cout Direct Labor Budget Direct Labor Hours Pard Costu GW Year 2018 Caber Comments Files (1) Rubric D Dashboard Calendar To Do Notifications Inbox 2:58 ull Submission Term Project Part 1: Current Financial Posi... Nov 19, 2020 at 8:41 AM Meer www Mater de Mar de se Geen Direct her Direct her Hours Cost Budget com come tratt en Deres Caberete Totector Trect Materiale Varme VA Totul articom contributing red retues provision form $ Comments Files (1) Rubric Dashboard Calendar To Do Notifications Inbox 3:00 ACC550_COURSE INFO_TermProjec... Grizzly Bear Winery (GBW) is a small winery in Portland, OR Kerry Smith is the CEO and President of the Board of Directors, which is made-up of local business owners and professionals. In 2018, GBW had a net margin loss of (-5%) on Sales of approximately $882,500. The company pays a 21% corporate tax rate in the year's when it has a profit. GBW has a relationship with a local vineyard owner who grows two types of wine grapes, a Cabernet and a generic red grape. Last year GBW bought 75,000 lbs. of Cabernet grapes, and 150,000 lbs of generic grapes. The vineyard can guarantee this amount every year. After the grapes are harvested, they are brought to the winery for processing into wine. The Cabernet wine is fermented in oak barrels. The generic wine is fermented in a stainless steel tank. GBW bottles three wines. Cabernet Estate, a Blended wine, and a Red Table wine The Cabernet Estate varietal contains only Cabemet grapes and requires 4 lbs of Cabernet grapes. The sales price is S23/bottle. The blended wine is made by combining 1 lb of Cabernet grapes and 2 lbs of generic grapes. The different grapes are fermented separately and blended before bottling. The sales price is $17/bottle. The Table wine is made from only generic grapes and requires 3 lbs of grapes. The sales price is $5.50 bottle. All three wines are packaged at the GBW facility. Current year Sales and unit prices are shown below. Demand for each product is expected to grow significantly, as shown. Table 1: Sales Datu Price per ben peted Demand 12.000 Blend 17.00 23.000 30.000 Tables SO 19.000 year) Since demand is strong and the company sells all of the wine it produces, the CEO suspects that one of the wine varictals is not profitable and is therefore causing the company to be in the red She needs your help in determining if any of the products are dragging down the profit margin, and if so, what should be done about it. She would like to know if she should cut-pay for some employees, raise prices, change the sales mix, or drop a product Additionally, the CEO was recently offered the opportunity to buy additional grapes from another vineyard at current market prices. With a fixed capacity of 95.000 bottles, the winery has had enough capacity to meet demand up to this point. Thus far, the only factor that has limited the amount of wine produced has been the number of pounds of grapes that were available to be purchased. The new supplier has can offer an additional 100.000 pounds of Cabernet grapes at $1.15/1b., and an additional 100,000 pounds of the generic grapes at S0.78/1b. G] Dashboard Calendar To Do Notifications Inbox 3:00