Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
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 solution
Students have asked these similar questions
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?
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?
Best Trim, a manufacturer of lawn mowers, predicts that it will purchase 204,000 spark plugs next year. Best Trim estimates that 17,000 spark plugs will be required each month. A supplier quotes a price of $9 per spark plug. The supplier also offers a special discount option: If all 204,000 spark plugs are purchased at the start of the year, a discount of 2% off the $9 price will be given. Best Trim can invest its cash at 10% per year. It costs Best Trim $260 to place each purchase order.
Q. Would this opportunity cost be recorded in the accounting system? Why?
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
- Best Trim, a manufacturer of lawn mowers, predicts that it will purchase 204,000 spark plugs next year. Best Trim estimates that 17,000 spark plugs will be required each month. A supplier quotes a price of $9 per spark plug. The supplier also offers a special discount option: If all 204,000 spark plugs are purchased at the start of the year, a discount of 2% off the $9 price will be given. Best Trim can invest its cash at 10% per year. It costs Best Trim $260 to place each purchase order. Q. What other factors should Best Trim consider when making its decision?arrow_forwardBest Trim, a manufacturer of lawn mowers, predicts that it will purchase 204,000 spark plugs next year. Best Trim estimates that 17,000 spark plugs will be required each month. A supplier quotes a price of $9 per spark plug. The supplier also offers a special discount option: If all 204,000 spark plugs are purchased at the start of the year, a discount of 2% off the $9 price will be given. Best Trim can invest its cash at 10% per year. It costs Best Trim $260 to place each purchase order. Q. What is the opportunity cost of interest forgone from purchasing all 204,000 units at the start of the year instead of in 12 monthly purchases of 17,000 units per order?arrow_forwardBest Trim, a manufacturer of lawn mowers, predicts that it will purchase 204,000 spark plugs next year. Best Trim estimates that 17,000 spark plugs will be required each month. A supplier quotes a price of $9 per spark plug. The supplier also offers a special discount option: If all 204,000 spark plugs are purchased at the start of the year, a discount of 2% off the $9 price will be given. Best Trim can invest its cash at 10% per year. It costs Best Trim $260 to place each purchase order. Q. Should Best Trim purchase 204,000 units at the start of the year or 17,000 units each month? Show your calculations.arrow_forward
- Anti-Corona, a distributor of facial mask, predicts that it will purchase 306,000 masks next year. Anti-Corona estimates that 25,500 masks will be required each month. A supplier quotes a price of $10 per facial mask. The supplier also offers a special discount option: If all 306,000 masks are purchased at the start of the year, a discount of 3% off the $10 price will be given. Anti-Corona can invest its cash at 12% per year. It costs Anti-Corona $300 to place each purchase order. (a)What is the opportunity cost of interest forgone from purchasing all 306,000 units at the start of the year instead of in 12 monthly purchases of 25,500 units per order? (b) Should Anti-Corona purchase 306,000 units at the start of the year or 25,500 units each month? Show your calculations with reasons 4(c) The company is a multinational company with many branches in different countries around the world. The 12% for return on cash is based on expected return of cash in US. The company is planning to…arrow_forwardYour firm spends $5,000 every month on printing and mailing costs, sending statements to customers. If the interest rate is 0.5% per month, what is the present value of eliminating this cost by sending the statements electronically?arrow_forwardIn 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_forward
- 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,000arrow_forwardA company is considering switching from a cash only policy to a net 30 credit policy. The price per unit is $700 and the variable cost per unit is $600. The company currently sells 1,000 units per month. Under the proposed policy the company expects to sell 1,200 units per month. The quarterly compounded APR is 15%. If you were using NPV analysis to decide whether the company should switch to the net 30 (1-month) credit policy, what amount would you use for the present value of the incremental cash flows?arrow_forwardSuppose Stanley's Office Supply purchases 50,000 boxes of pens every year. Ordering costs are $100 per order, carrying costs are 5% of the inventory value, and the price is of $2.00 per box. The vendor now offers a quantity discount of 1% per box if the company buys pens in order sizes of 20,000 boxes. Should the company accept the quantity discount? Show your calculations to justify your decision.arrow_forward
- 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,000arrow_forwardGelmite & Sons Hardware is considering introducing a cash discount policy to its customers so as toimprove current sales. There are three possible scenarios that include monthly estimates. Gelmite& Sons uses a 60% mark up on cost on all their products as a general rule. Fixed costs are R8 000per month. Scenario A: Representing the Current ScenarioCompany sold 600 units of the spark nail which they ordered at a wholesaler in Shoppers Town fora cost price of R100 each. Scenario B: Representing initial sales target Company will sell 800 units of the spark nail which they ordered at a wholesaler in Shoppers Townfor a cost price of R100 each.These sales units are achieved after the introduction of a 20% markdown on the original sellingprice.Scenario C: Representing a scenario where sales targets are surpassed Company will sell 1 000 units of the spark nail which they ordered at a wholesaler in Shoppers Townfor a cost price of R100 each. In order to achieve the increased sales,…arrow_forwardMicrobiotics currently sells all of its frozen dinners cash-on-delivery but believes it can increase sales by offering supermarkets 1 month of free credit. The price per carton is $50, and the cost per carton is $40. The unit sales will increase from 1,150 cartons to 1,210 per month if credit is granted. Assume all customers pay their bills and take full advantage of any credit period offered. a. If the interest rate is 1% per month, what will be the change in the firm's total monthly profits on a present value basis if credit is offered to all customers? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. If the interest rate is 1.5% per month, what will be the change in the firm's total monthly profits on a present value basis if credit is offered to all customers? (Do not round intermediate calculations. Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.) c. Assume the interest rate is…arrow_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