Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. Using Figure 16.3 as a guide, prepare a cumulative and daily cost-to- sales ratio chart given the following information: Date 10/1 10/2 10/3 10/4
5. Using Figure 16.3 as a guide, prepare a cumulative and daily cost-to- sales ratio chart given the following information: Date 10/1 10/2 10/3 10/4 10/5 Cost $250 225 270 290 240 Sales $ 910 850 920 1,070 900 6. Using the figures in Question 5, prepare a chart in the form illustrated in Figure 16.5 to include the following additional information: Food Transferred Liquor Transferred Date to Bar to Kitchen 10/1 $15 $25 10 30 10/3 12 45 10/4 20 10 10/5 8 18 10/2 Sales Cost % Today To Date 28.9% FIGURE 16.5 . Daily Beverage Cost Calculations with Adjustments, the Grandview Bistro Beverages Total Cost Date Issued Additions Subtractions Today To Date 1-Feb $130.85 $ 9.65 $22.35 $118.15 2-Feb $125.60 $20.00 $30.15 $115.45 $233.60 3-Feb $ 90.40 $14.80 $20.00 $ 85.20 $318.80 4-Feb $ 88.90 $22.75 $32.70 $ 78.95 $397.75 5-Feb $ 90.30 $44.60 $16.30 $118.60 $516.35 6-Feb $110.60 $ 5.50 $33.40 $ 82.70 $599.05 27.4% 28.1% Today To Date $409.50 $420.70 $ 830.20 $390.65 $1,220.85 $370.60 $1,591.45 $432.85 $2,024.30 $422.70 $2,447.00 21.8% 26.1% 21.3% 25.0% 27.4% 25.5% 19.6% 24.5% 5. Using Figure 16.3 as a guide, prepare a cumulative and daily cost-to- sales ratio chart given the following information: Date 10/1 10/2 10/3 10/4 10/5 Cost $250 225 270 290 240 Sales $ 910 850 920 1,070 900 6. Using the figures in Question 5, prepare a chart in the form illustrated in Figure 16.5 to include the following additional information: Food Transferred Liquor Transferred Date to Bar to Kitchen 10/1 $15 $25 10 30 10/3 12 45 10/4 20 10 10/5 8 18 10/2 Sales Cost % Today To Date 28.9% FIGURE 16.5 . Daily Beverage Cost Calculations with Adjustments, the Grandview Bistro Beverages Total Cost Date Issued Additions Subtractions Today To Date 1-Feb $130.85 $ 9.65 $22.35 $118.15 2-Feb $125.60 $20.00 $30.15 $115.45 $233.60 3-Feb $ 90.40 $14.80 $20.00 $ 85.20 $318.80 4-Feb $ 88.90 $22.75 $32.70 $ 78.95 $397.75 5-Feb $ 90.30 $44.60 $16.30 $118.60 $516.35 6-Feb $110.60 $ 5.50 $33.40 $ 82.70 $599.05 27.4% 28.1% Today To Date $409.50 $420.70 $ 830.20 $390.65 $1,220.85 $370.60 $1,591.45 $432.85 $2,024.30 $422.70 $2,447.00 21.8% 26.1% 21.3% 25.0% 27.4% 25.5% 19.6% 24.5%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started