Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

webapps/assassment/take/launch-jsp?course_assessment id=_235320_1&course_jd=_200162_1&contenit jd=_7690951 mining Time: 30 minutes, 30 seconds. tion Completion Status: QUESTION 43 Use the information from the spreadsheet below. Determine the correct computations

image text in transcribed
webapps/assassment/take/launch-jsp?course_assessment id=_235320_1&course_jd=_200162_1&contenit jd=_7690951 mining Time: 30 minutes, 30 seconds. tion Completion Status: QUESTION 43 Use the information from the spreadsheet below. Determine the correct computations for spaces $1.290.00 and Be sure to place a number sign (s) in front of your response and round to the hundreths place. Also use camas for oumbers $1,000.00 You should also write any percentages in common form with the percentage sign (eg. 75% or 42.5%). Stella operates a Cuban-themed food truck that sells sandwiches and drinks to office workers in the downtown area of a mid-sized city, Stella has been approached by the Grab-On coupon company to enter a partnership arrangement with them, whereby Grab-On would on their own website, sell coupons good for $20.00 worth of Stella's food and beverage products. The $20.00 coupons would sell for 510.00 each, and Grab On would split the sales proceeds 50/50 with Stella. The sold coupons would have a 30-day expiration period, and Grab-On states that in their experience, only 90 percent of the sold coupons will be redeemed prior to their expiration date. Stella has already begun forecasting the next 30 day's sales and product expenses (without the coupon programl as well as her estimated guest count and CM per guest. Recalculate Stella's projected financial results assuming her original forecast and the sale of 10 100, and 500 Grab-On coupons Hint: Guests served at 100 coupons sold is 1,290 0 100 SOO Steta's Food Truck of Coupons Sold Forecast Noncoupon revenue Coupons Total Revenue Novoupon productos Coupon product To Product Cout Contbution man Que served Con Magnet $15,000.00 1000 $15.000.00 34 500.00 50.00 54.50000 10 5 100.00 $15.000.00 ON 550.00 100.00% $15.050 DO 30.00N $4,500.00 533 75 C 54.533.75 70.00 110.510 25 1.200 38.70 99.67% 515.000.00 0.33% D 100.00% E 3000 $4.500.00 225 F 30 22 69 N HE 96.77 515.00000 3.23 $2.500.00 100.00% 517 500.00 30.00N 4 500.00 $1.687.50 3218 16 17:50 58.19 $11.312.50 1.550 500 85,71% T4.29 100.00% 30.ON 0.04% 39.60 54 1.200 MacBook Air go GOD 15 00 FS FS FB 110 # % webapps/assassment/take/launch-jsp?course_assessment id=_235320_1&course_jd=_200162_1&contenit jd=_7690951 mining Time: 30 minutes, 30 seconds. tion Completion Status: QUESTION 43 Use the information from the spreadsheet below. Determine the correct computations for spaces $1.290.00 and Be sure to place a number sign (s) in front of your response and round to the hundreths place. Also use camas for oumbers $1,000.00 You should also write any percentages in common form with the percentage sign (eg. 75% or 42.5%). Stella operates a Cuban-themed food truck that sells sandwiches and drinks to office workers in the downtown area of a mid-sized city, Stella has been approached by the Grab-On coupon company to enter a partnership arrangement with them, whereby Grab-On would on their own website, sell coupons good for $20.00 worth of Stella's food and beverage products. The $20.00 coupons would sell for 510.00 each, and Grab On would split the sales proceeds 50/50 with Stella. The sold coupons would have a 30-day expiration period, and Grab-On states that in their experience, only 90 percent of the sold coupons will be redeemed prior to their expiration date. Stella has already begun forecasting the next 30 day's sales and product expenses (without the coupon programl as well as her estimated guest count and CM per guest. Recalculate Stella's projected financial results assuming her original forecast and the sale of 10 100, and 500 Grab-On coupons Hint: Guests served at 100 coupons sold is 1,290 0 100 SOO Steta's Food Truck of Coupons Sold Forecast Noncoupon revenue Coupons Total Revenue Novoupon productos Coupon product To Product Cout Contbution man Que served Con Magnet $15,000.00 1000 $15.000.00 34 500.00 50.00 54.50000 10 5 100.00 $15.000.00 ON 550.00 100.00% $15.050 DO 30.00N $4,500.00 533 75 C 54.533.75 70.00 110.510 25 1.200 38.70 99.67% 515.000.00 0.33% D 100.00% E 3000 $4.500.00 225 F 30 22 69 N HE 96.77 515.00000 3.23 $2.500.00 100.00% 517 500.00 30.00N 4 500.00 $1.687.50 3218 16 17:50 58.19 $11.312.50 1.550 500 85,71% T4.29 100.00% 30.ON 0.04% 39.60 54 1.200 MacBook Air go GOD 15 00 FS FS FB 110 # %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Investment Strategies Structures Decisions

Authors: David Hartzell, Andrew E. Baum

2nd Edition

1119526094, 978-1119526094

More Books

Students also viewed these Finance questions

Question

4 of 10 Find the area to the right of z = 3.25

Answered: 1 week ago

Question

Explain the causes of indiscipline.

Answered: 1 week ago

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago