Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 21, Problem 6R
Reset cells to their initial values. Sweet Pleasures, Inc., is considering undertaking a $1,200 per month advertising campaign to promote Sweet Pleasures chocolate as exclusive and extraordinarily tasty. What price (dollars and cents) would Sweet Pleasures have to charge for each box to be able to pay for the campaign, pay back the $10,000 note, and have $15,000 left over at the end of April? (Try different prices in cell C9.)
Sales price $___
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Solve each of the following questions using both pricing formulas and Excel.
5. You are managing a small company and need to buy some equipment for your product line. Kangaroo Manufacturing is offering free credit on a $20,000 piece of equipment. You pay down $2,000 and then $600 a month for the next 30 months. Turtle Machines does not offer free credit but will give you $2,000 off the list price. If the rate of interest is 10% (APR) a year, which company is offering a better deal?
Use the information for the question(s) below.Food For Less (FFL), a grocery store, is considering offering one hour photo developing in their store. The firm expects that sales from the new one hour machine will be $150,000 per year. FFL currently offers overnight film processing with annual sales of $100,000. While many of the one hour photo sales will be to new customers, FFL estimates that 60% of their current overnight photo customers will switch and use the one hour service. The level of incremental sales associated with introducing the new one hour photo service is closest to:
A. $60,000
B. $90,000
C. $150,000
D. $120,000
Use the information for the question(s) below.Food For Less (FFL), a grocery store, is considering offering one hour photo developing in their store. The firm expects that sales from the new one hour machine will be $150,000 per year. FFL currently offers overnight film processing with annual sales of $100,000. While many of the one hour photo sales will be to new customers, FFL estimates that 60% of their current overnight photo customers will switch and use the one hour service. Suppose that of the 60% of FFL's current overnight photo customers, half would start taking their film to a competitor that offers one hour photo processing if FFL fails to offer the one hour service. The level of incremental sales in this case is closest to:
A. $150,000
B. $120,000
C. $60,000
D. $90,000
Chapter 21 Solutions
Excel Applications for Accounting Principles
Ch. 21 - On January 1, Sweet Pleasures, Inc., begins...Ch. 21 - Open the file CASHBUD from the website for this...Ch. 21 - Can the 10,000 note be repaid on May 1? Explain.Ch. 21 - Prob. 4RCh. 21 - The following four suggestions have been made to...Ch. 21 - Reset cells to their initial values. Sweet...Ch. 21 - Prob. 7R
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Hyperion, Inc. currently sells its latest high-speed color printer, the Hyper 500, for $350. It plans to lower the price to $300 next year. Its cost of goods sold for the Hyper 500 is $200 per unit, and thi year's sales are expected to be 20,000 units.a) Suppose that if Hyperion drops the price to $300 immediatley, it can increase this year's sales by 25% to 25,000 units. What would be the incremental impact on this eyar's EBIT of such a price drop?b) Suppose that for each printer sold, Hyperion expects additional sales of $75 per year on ink cartridges for the next years, and Hyperion has a gross profit margin of 70% on ink cartridges. What is the incremntal impact on EBIT for the next three years of a priced drop this year?arrow_forward1. Your new company is planning to make and sell customized mailboxes. You have set startup costs of $2046. Each mailbox costs you $34 to make. If you plan to sell your mailboxes for $49.50, how many must you make and sell to break even? Explain the how you determined the answer. 2. If the retail price is fixed at $1.00, what effect does increasing the retail and wholesale margins have on the manufacturer's selling price? Explain why this is the case. 3. Define unit contribution in your own words. Is a high or low unit contribution preferable for profitability? 4. How do increases in the retail and wholesale margins (again, with a fixed retail price) affect the unit contribution? Why? 5. If you increase any of the fixed cost factors, what happens to the number of units the company needs to sell to break even? To the market share necessary to achieve breakeven?. 6. What change (increase or decrease) to the following factors increases the profit impact? Decreasing retail margin/unit…arrow_forwardPhlight Restaurant is considering a delivery service. The firm expects that sales from the new service will be $150,000 per year. Phlight currently offers a sit-down service with annual sales of $100,000. While many of the delivery sales will be to new customers, Phlight estimates that 60% of their current sit-down customers will switch and use the delivery service. The level of incremental sales associated with introducing the delivery service is closest to: Select one: a. $90,000 b. $150,000 c. $60,000 d. $120,000arrow_forward
- Investing $2,000,000 in TQM's Channel Support Systems initiative will at a minimum increase demand for your products 3.0% in this and in all future rounds. (Refer to the TQM Initiative worksheet in the CompXM Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,608,638. Assuming similar sales next year, the 3.0% increase in demand will provide $4,908,259 of additional revenue. With the overall contribution margin of 34.2%, after direct costs this revenue will add $1,678,625 to the bottom line. For simplicity, assume that the demand increase and margins will remain at last year's levels. How long will it take to achieve payback on the initial $2,000,000 TQM investment, rounded to the nearest month? A. 10 months B. TQM investment will not have a significant financial impact C. 14 months D. 5 monthsarrow_forwardA chain of take-away pizza stores is considering introducing a new line of gluten-free pizzas. Net revenue from the new line of pizzas is expected to total $500,000 per year, but 15% of this net revenue is forecast to consist of people switching from the regular pizzas to the gluten-free pizzas. How would you describe this situation in terms of the NPV analysis upon which the situation will be based. Question 1Answer a. There is a negative externality equal to $425,000 which should be included in the NPV analysis for the gluten-free pizza project. b. There is a positive externality equal to $425,000 which should be included in the NPV analysis for the gluten-free pizza project. c. There is a positive externality equal to $75,000 which should be included in the NPV analysis for the gluten-free pizza project. d. There is a negative externality equal to $75,000 which should be included in the NPV analysis for the gluten-free pizza project.arrow_forwardDerby phones is considering the introduction of a new model of headphones with the following price and cost characteristics. A. What number must Derby sell per month to break-even? B. What number must Derby sell to make an operating profit of $180,000 for the month?arrow_forward
- In an effort to increase sales, Alabama Company inaugurated a sales promotional campaign on June 30, 2022. The company placed a coupon redeemable for a plushy in each package of cereal sold. To receive a premium, a customer must present five (5) coupons. Each plushy cost the firm P20, while it can be sold by Alabama for P50 each. The company estimates that only 45% of the coupons issued will not be redeemed. For the six months ended December 31, 2022, the following information are available: Packages of cereal sold 170,000 Selling price per box of cereal P100 Plushies purchased 25,000 Coupons actually redeemed 80,000 (a) How much is the premium expense for the year ended December 31, 2022? (b) How much is the estimated liability for premium claims as of December 31, 2022? (c) How much is the inventory of premium items as of December 31, 2022?arrow_forwardProvide a formula in the solution. Thank you! ABC Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be P100,000. Variable production and material costs are estimated to be P150 per book. Demand over the life of the book is estimated to be 4,000 copies. The publisher plans to sell the text to college and university bookstores for P1,000 each. 1. What profit or loss can be anticipated with a demand of 4000copies?2. With a demand of 4000 copies, what is the minimum price percopy that the publisher must charge to break even?3. If the publisher believes that the price per copy could beincreased to P1,297.50 and would not affect the anticipateddemand of 4000 copies, what action would you recommend?4. What profit or loss can be anticipatedarrow_forwardDona Corporation manufactures and sells T-shirts imprinted with college name and slogans. Last year, the shirts sold for P7.50 each, and the variable cost to manufacture them was P2.25 per unit. The company needed to sell 20,000 shirts to breakeven. The net income last year was P5,040. Dona’s expectation for the coming year include the following: • The sales price of the t-shirt will be P9.00 • Variable cost to manufacture will increase by one-third. • Fixed cost will increase by 10% • The income tax rate of 40% will be unchanged a. The selling price that would maintain the same contribution margin rate as last year is ______________- b. The number of T-shirts Dona must sell to break even in the coming year is ______________ c. If Dona wishes to earn P22,500 in net income for the coming year, the company’s sales in pesos must be __________arrow_forward
- Hyperion, Inc. currently sells its latest high-speed colour printer, the Hyper 500, for $371. It plans to lower the price to $318 next year. Its cost of goods sold for the Hyper 500 is $212 per unit, and this year's sales are expected to be 21,000 units. a. Suppose that, if Hyperion drops the price to $318 immediately, it can increase this year's sales by 27% to 26,670 units. What would be the incremental impact on this year's EBIT of such a price drop? b. Suppose that, for each printer sold, Hyperion expects additional sales of $78 per year on ink cartridges for the three years, and Hyperion has a gross profit margin of 61% on ink cartridges. What is the incremental impact on EBIT for the next three years of a price drop this year?arrow_forwardAfter a successful year for your beach shop, you are wondering whether to open one more store this year. There are equal chances for the coming summer to be rainy or sunny. If the weather is sunny, you will earn $55,000 in profits per store. However, if the weather is rainy, your profit will be $35,000 if you open one store and zero if you open two stores. What is your expected profit under complete information? O A $110,000 OB. $55,500 OC. $90,000 D. $72,500arrow_forwardTo increase sales, DD Company inaugurated a promotional campaign on June 30, 2020. DD placed a couponfor a premium in each box of cake sold at P400. A coffee mug costing P60 is offered as premium to customers who sendin 5 coupons and a remittance of P20. The distribution cost per premium is P10. DD Company estimated that only80% of the coupons issued will be redeemed. For the six months ended December 31, 2020, the following data isavailable in terms of units:Boxes of cake sold 20,000Premiums purchased 3,000Coupons redeemed 10,000What is the estimated liability for premiums on December 31, 2020?a. P180,000 b. P150,000 c. P160,000 d. P60,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
7.2 Ch 7: Notes Payable and Interest, Revenue recognition explained; Author: Accounting Prof - making it easy, The finance storyteller;https://www.youtube.com/watch?v=wMC3wCdPnRg;License: Standard YouTube License, CC-BY