The owner of Maxwell's Coffee and Cakes wants to start selling products that feature her coffee shop's logo. Her first product will be backpacks which she will sell for $137.44 each. She can buy the backpacks for $21.97 and have them customized for $10.92 apiece. There is a one-time set up charge of $1,525.15 for customization. In order for the project to go forward, she needs to show a $14,718.68 profit. How many backpacks will she have to sell in order for this project to be acceptable? Round to the nearest whole number.

The owner of Maxwell's Coffee and Cakes wants to start selling products that feature her coffee shop's logo. Her first product will be backpacks which she will sell for $137.44 each. She can buy the backpacks for $21.97 and have them customized for $10.92 apiece. There is a one-time set up charge of $1,525.15 for customization. In order for the project to go forward, she needs to show a $14,718.68 profit. How many backpacks will she have to sell in order for this project to be acceptable? Round to the nearest whole number.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

INSTRUCTIONS: We're looking to work with a new publisher that is interested in selling us two different placements. The publisher has told us that placement 1 has an approximate CTR of 0.3% and will get 2M impressions per month. Placement 2 has an approximate CTR of 0.4% and will get 3M impressions. The CPM for Placement 1 is $5, CPM for Placement 2 is 6$ The conversion rate of our landing page is 8% and the leads generated all are worth $50. Please use the worksheet outlined below to fill in the highlighted cells with the answers you find. 1. What is the total cost? 2. What is the total revenue and retutn on ad spend? 3. What is the total clickthrough rate (CTR)? 4. Which placement is more effective in terms of ROAS? Placement 1 Placement 2 Total Impressions 2,000,000 3,000,000 CTR 0.30% 0.40% CR 8.00% 8.00% Clicks Leads = Impressions * CTR = Clicks * CR Revenue = Leads RPL DEFINITIONS: Revenue: Money generated from leads submitted by visitors filling out forms. Impressions: The…
Preliminary plans are underway for construction of a new stadium for a major league baseball team. City officials question the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may purchase a box for $300,000. The fixed construction cost for the upper-deck area is estimated to be $4,500,000, with a variable cost of $150,000 for each box constructed. a. What is the breakeven point for the number of luxury boxes in the new stadium? b. Preliminary drawings for the stadium show that space is available for the construction of up to 50 luxury boxes. Promoters indicate that buyers are available and that all 50 could be sold if constructed. What is your recommendation concerning the construction of luxury boxes? What profit is anticipated?
You are working in the planning team of a food factory in Malaysia, producing Lipton. Tomorrow is the deadline for shipping deliveries to Giant supermarkets ready for a new Lipton promotion. The promotion has featured an extensive social media campaign to drive sales. You have just been informed that the delivery of raw materials has broken down. There is a risk that the tight manufacturing schedule will not be feasible in the time remaining. So in this case, 1-Who dod you need to keep informed? 2. What method of communication would you choose for each?
Explain how can minimization be performed with simplex methods ?
1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift. Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately? NUYLOTNQhObm1bEVKUTO90 a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry. O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this. CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby. 40 Cara's gift is very thoughtful and will help to build a relationship with her clients. NUTYks10TNRUQ2h0bmkbEVKUTO90
Mikey W. Smitty, an emerging rapper, is getting ready tocut his first CD, called “Western Rap.” The cost of recording the CD is $5000 but copies are $5 apiece. If the CDscan be sold for $15 each, how many CDs must be sold tobreak even? What is the breakeven point in dollars?
The Betterbilt Construction Company designs and builds residential mobile homes. Thecompany is ready to construct, in sequence, 16 new homes of 2,400 square feet each. Thesuccessful bid for the construction materials in the first home is $64,800, or $27 per square foot.The purchasing manager believes that several actions can be taken to reduce material costs by8% each time the number of homes constructed doubles. Based on this information,a. What is the estimated cumulative average material cost per square foot for the first fivehomes?b. What is the estimated material cost per square foot for the last (16th) home?
Today you got the budget approval from the Vice President to schedule the training session and pay Prof. Jim Salu his professional fee and reimburse him for expenses up to GH¢500.00. He will have to submit all receipts and an itemised list of expenses to be reimbursed. You cannot reimburse him if he does not have receipts. You also have to explain the mechanics of the training session. You will use the company conference room, which has a screen, flip charts an overhead projector and VCR, but you will need to reserve them if the Professor wants to use them. Write a letter to Professor Jim Salu. You do not have to persuade him since he had already informally agreed, but you do want him to look forward to the job and to do his best work.
Alex owns a shop that sells customized BMX bikes. Each one is uniquely tailored to the rider. The products are unique one-offs, made by an outsourced company to individual designs agreed between Alex and a designer from the outsourced company. In WEEK 26, Alex discusses with the manufacturer a design for a new bike. Alex and the manufacturer agree on a specification and an order is placed with the manufacturer. A. Calculate how long it will take before the BMX bike is available for sale in Alex's shop. That is, what is the Lead-Time between Alex placing order with her manufacturer and being able to display the item for sale in her shop? The information you need to calculate the Lead-Time is as follows: To design the bike 2 weeks To raise the order for the parts for the bike 1week To manufacture and deliver all the parts of the bike 4 weeks To assemble the bike 2 weeks To deliver the finished product to Alex’s shop 1 week B. What will be the week number when the Bike can be…
Explain the importance of stakeholder involvement in requirement analysis and its impact on project success.
Two months ago Harry was asked to prepare cash budget with a very short notice. He did an excellent job and handled it before the due date. However his supervisor didn’t even notice that it was a very good job, he immediately assigned another hard job. The managers had treated Sue in the same manner last year. Now Sue has been asked to prepare a feasibility report for the new production facility that the firm was thinking of building. Although it is a hard job, Sue thinks that she will be able to prepare a very good report. However she is very unwilling to prepare it and although time is limited she hasn’t even started to prepare. Sue and Harry began to discuss their supervisors. They thought that their supervisor doesn’t care about their well-being, but he is ready whenever supervision is needed. He clarifies the tasks well, and helps the employees to solve problems related to the job but otherwise, he never interferes. On the other hand, the leader doesn’t let employees try new…
Bill of material (BOM) details all the sub-component, material, and parts used to make one product. There is a dinner party at your home of a few guests, and you are managing your kitchen. Develop a BOM of any main dish (main course) of your own choice in a tree format. (Hint: Select number of people that will be served with dinner and quantity of that main course to be prepared in appropriate units) Let us assume that you are managing the complete food for dinner, and the food will be served at 9:00 PM sharp. You have decided to serve one main course item, as mentioned in the previous part (a), one sweet dish of your choice, and salad. Prepare a lead-time tree for your complete project and explain the total lead-time from start preparation to serving the dinner for your guests. Secondly, what is the latest time you must start preparing your dinner?