Question

In: Accounting

A bakery runs a Groupon campaign. $3 cost for $8 value 50/50 split with Groupon 70%...

A bakery runs a Groupon campaign. $3 cost for $8 value 50/50 split with Groupon 70% of coupons redeemed 1,200 coupons sold Average ticket value: $11 Bakery’s gross margin: 45%

A. Calculate the revenue from the campaign

B. Calculate the restaurant expenses associated with the Groupon customers.

C. Assume that the campaign generated 75 new customers. Calculate the breakeven sales revenue for a new customer.

Solutions

Expert Solution

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605


Related Solutions

Problem 8-50 Prepare a Production Cost Report and Adjust Inventory Balances: Weighted-Average Method (LO 8-3, 4)...
Problem 8-50 Prepare a Production Cost Report and Adjust Inventory Balances: Weighted-Average Method (LO 8-3, 4) The records of Fremont Corporation’s initial and unaudited accounts show the following ending inventory balances, which must be adjusted to actual costs. Units Unaudited Costs Work-in-process inventory 215,000 $ 818,897 Finished goods inventory 26,000 366,250 As the auditor, you have learned the following information. Ending work-in-process inventory is 40 percent complete with respect to conversion costs. Materials are added at the beginning of the...
Maria Bakery is considering a 3-year project with an initial cost of $93,000. The project will...
Maria Bakery is considering a 3-year project with an initial cost of $93,000. The project will not directly produce any sales but will reduce operating costs by $31,000 a year. The equipment is classified as MACRS 7-year property. The MACRS table values are .1429, .2449, .1749, .1249, .0893, .0892, .0893, and .0446 for Years 1 to 8, respectively. At the end of the project, the equipment will be sold for an estimated $43,270. The tax rate is 34 percent and...
What is the value of $1000 par value 8 3/8% Marriott Corporation bond for the for...
What is the value of $1000 par value 8 3/8% Marriott Corporation bond for the for each of the following required rates of return and assuming that the investor will hold the bond to maturity assume the coupon is paid semiannually (every six months) and the mature the bond matures in three years? a. 6.50% b. 11.30%
A cable runs along the wall from C to P at a cost of ​$3 per​...
A cable runs along the wall from C to P at a cost of ​$3 per​ meter, and straight from P to M at a cost of ​$5 per meter. If M is 16 meters from the nearest point A on the wall where P lies, and A is 59 meters from C, find the distance from C to P such that the cost of installing the cable is minimized and find the cost
Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...
Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70 5 Draw a Histogram Draw a polygon After listening to YouTube “histogram and polygon,” explain how histogram is different and similar to polygon.
Computing Joint Costs—Sales Value at Split-Off and Net Realizable Value Methods LeMoyne Manufacturing Inc.’s joint cost...
Computing Joint Costs—Sales Value at Split-Off and Net Realizable Value Methods LeMoyne Manufacturing Inc.’s joint cost of producing 2,000 units of Product X, 1,000 units of Product Y, and 1,000 units of Product Z is $50,000. The unit sales values of the three products at the split-off point are Product X–$30, Product Y–$100, and Product Z–$90. Ending inventories include 200 units of Product X, 300 units of Product Y, and 100 units of Product Z. In your interim calculations, round...
8. A 100 W load is connected to a 50 W transmission line. Determine the value...
8. A 100 W load is connected to a 50 W transmission line. Determine the value of the reactance to put in series at the input to the line and the length in wavelengths of the shortest transmision line to match with a 50 W source.
3. Profit maximization using total cost and total revenue curves Suppose Ana runs a small business...
3. Profit maximization using total cost and total revenue curves Suppose Ana runs a small business that manufactures shirts. Assume that the market for shirts is a competitive market, and the market price is $20 per shirt. The following graph shows Ana's total cost curve. Use the blue points (circle symbol) to plot total revenue and the green points (triangle symbol) to plot profit for shirts quantities zero through seven (inclusive) that Ana produces. Calculate Ana's marginal revenue and marginal...
Find out whether or not the integer pairs are relatively prime: (8, 15), (6, 50), (3,...
Find out whether or not the integer pairs are relatively prime: (8, 15), (6, 50), (3, 31) and (3, 21). Is the set of all real numbers under the arithmetic addition and multiplication a field? Justify your answer. Consider a set S={a,b} with addition and multiplication defined by: a+a=a, a+b=b, b+a=b, b+b=a, axa=a, axb=a, bxa=a, bxb=b. Is S a ring? Justify your answer.
a. Chile Co. has 1,000 shares of 8%, $50 par value,cumulative preferred stock and 50,000...
a. Chile Co. has 1,000 shares of 8%, $50 par value, cumulative preferred stock and 50,000 shares of $1 par value common stock outstanding at December 31, 2016.  In 2016, $10,000 of dividends are declared and paid. No dividends were paid in2015.  What are the dividends received by the common stockholders in 2016?b. The entry to record the full payment of the premium on a two-year insurance policy would be:-debit to prepaid insurance, credit to accounts receivable-debit to prepaid insurance, credit to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT