Question: how do I put #2 in a excel spreadsheet? Please provide the solution of the following questions. You need to review the lecture video, chapter
how do I put #2 in a excel spreadsheet?
Please provide the solution of the following questions. You need to review the lecture video, chapter 1 of the textbook, and presentation. Please include the formula and final result in the Excel sheet. All files should be uploaded to your D2L portal. 1. A Website has a fixed cost of $15,000 per day. The revenue is $0.06 each time the website is accessed. The variable cost of responding to each hit is $0.02. (a) How many times must this website be accessed each day to break even? (b) What is the break-even point, in dollars? 2. A distributer of prewashed shredded lettuce is opening a new plant and considering whether to use a mechanized process or a manual process to prepare the product. The manual process will have a fixed cost of $43,400 per month and a variable cost of $1.80 per 5-pound bag. The mechanized process would have a fixed cost of $84,600 per month and a variable cost of $1.30 per bag. The company expects to sell cach bag of shredded lettuce for $2.50. (a) Find the break-even point for each process. (b) What is the monthly profit or loss if the company chooses the manual process and sells 70,000 bags per month
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
