Could you please assist with answering questions 1a 1b 1c 2

Could you please assist with answering questions 1a, 1b, 1c, 2, and 3 with all the required formulas and/or required materials? If you could show in Excel, that would be really helpful.

Case John Lefarge, the marketing manager is very keen to add more products: \"The name of the game is to add more and more products to drive traffic through the store regardless of whether we make money on each one. On the bundle of products that the customer buys, we are bound to make money. ON-THE-GO: Cost-Volume-Profit Analysis Peter Kankel, the CFO of On-the-Go convenience stores, had only a couple of hours to decide what he would recommend. Decisions to add products are often challenging. Kankel knows that modern convenience stores have to do more than just remain open late into the evening and offer a diverse product assortment; they have to change with the times or face extinction. Over the years, On-the-Go has stocked new products and services, such as gasoline, lottery tickets, and even Internet shopping and delvery services. A walk through any of its stores is likely to reveal in excess of 2,000 different products and services, often available 24 hours a day, seven days a week. There are close to 150,000 convenience stores scattered across the United States. The industry generated $350 billion in sales for 2011 Susan Polk, the operations manager, has a different view: \"We know that convenience store customers don\'t like to wait in line for service. They want to be in and out fast. The more products we add and the more complexity we create, the longer it takes for customers to find what they want and to check out of the store. Also, different tasks require different skills. For example, if we make deli sandwiches, we need one of our more senior workers to prepare the sandwiches so it costs more to do that activity than to stock the shelves. I hope our accounting systems correctly reflect these higher costs.\" Kankel wondered how he should consider these arguments. He knew he could not put numbers on what Lefarge and Polk were saying, but they seemed like important points for him to consider as he made recommendations to the CEO, Patrick Newhouse On-the-Go Stores, based in Newport, Rhode Island, operates 82 stores in its chain of conve- nience stores. Locations are primarily in the New England and Mid-Atlantic regions of the United States, where there are about 20,000 convenience stores-approximately 13% of the country\'s total. The average sale is $3.00, with a gross margin of 30% Required 1. (a) Calculate the contribution margin per unit for money orders. (b) Calculate how many Recently, On-the Go has faced some challenging decisions. For example, company man- agers recently evaluated the effect on income of the store\'s sales mix and performed sensitivity analysis to see the effect on operating income of changing the selling price of milk. Kankel was currently evaluating two major decisions. money orders each On-the-Go location would need to sel each month to break even on th service. (c) Calculate how many money orders each On-the-Go location would need 10 sell each month to earn an operating income of $140 per month. 2. On the basis of financial considerations alone, should On-the-Go sell deli sandwiches? If so should the store purchase prepackaged sandwiches or make them in the store? What other factors, if any, regarding the sandwiches should Peter Kankel consider? The first decision related to the sale of money orders at its stores. This was a new product area for the company-a \"financial service,\" much like what a bank would offer. By offering this new service, On-the-Go hoped to boost its customer count. Previous studies had shown that customers were likely to buy more than just the items they originally intended to purchase. So, On-the-Go wanted to boost sales revenue by giving customers another reason to come into the store-and buy more than intended 3. Suppose On-the-Go can sell 300 money orders each month and 24 deli sandwiches during lunchtime each day. What should Peter Kankel recommend to Patrick Newhouse about sell- ing money orders and deli sandwiches? How should Kankel consider the issues that Lefarge and Polk raised in reaching his recommendation? Kankel had obtained the following information. The cost of renting the machine for each store to prepare money orders is $30 per month. The lease rent for the store is $5,000. For each money order processed, On-the-Go would pay a processing fee of 6 cents. After conducting an informal survey of banks and other local businesses that offered money order services, On-the- Go found that most charged 99 cents for each money order transaction. On-the- Go planned to set its money order fee at 79 cents to undercut local competition. Kankel estimated that a money order transaction would take one counter clerk 90 seconds to complete, versus only 30 seconds for ringing up a product sale. The average hourly wage for a store clerk is $12.00 per hour. On-the- Go does not plan to hire any new clerks or ask existing clerks to work longer hours if it decides to sell money orders. Could you please show all equations and/or formulas for the required questions, 1a/1b/1c, 2, and 3, so I can understand how you arrived at your answer? Kankel then turned to the second major decision he faced: Should On-the-Go sell in-store deli sandwiches to lunchtime customers? If it chose to sell deli sandwiches, On-the-Go could either prepare these sandwiches in-store or purchase prepackaged dei sandwiches from an outside vendor. It would cost $3.50 to purchase the sandwiches. If it made the sandwiches, the cost of the ingredients would be $2.50 per sandwich. One of On-the-Go\'s senior employees, who is paid $15 per hour, would prepare the sandwiches during the lunch hour. On-the-Go would then have to hire a temiporary worker for the 2-hour lunchtime period to manage other activities in the store. The temporary worker would be paid $10 per hour. The average selling price of a deli sandwich is $4.50. On-the-Go anticipates selling 12 sandwiches per hour. All other costs would be unchanged whether On-the Go buys the sandwiches, makes the sandwiches, or chooses not to sell sandwiches at all Excel would be incredibly helpful. Thank you!

Solution

1) a. Selling Price $0.79 Less: Variable Cost Direct Labour ($12.00 per hour/60 minutes) × 1.5 minutes $0.30 Processing fee $0.06 $0.36 Contribution Margin $0.43 per unit 90 seconds = 1.5 min b. BEP = Fixed Cost / Contribution Margin BEP = $30/$0.43 per unit 69.77 Money orders per month c. BEP(Target Profit) = (FC + Target Profit)/ Contribution margin BEP(Target Profit) = ($30 + $140)/ .43 395.35 Money orders per month