Question: in excel please with excel solver Problem 1 You are thinking of opening a small copy shop and rent a copier. It costs you $1.000
in excel please with excel solver
Problem 1 You are thinking of opening a small copy shop and rent a copier. It costs you $1.000 to rent a copier for a year and it costs you $0.03 per copy to operate the copier. Other fixed costs of running the store amount to $150 per month. You are planning to charge $0.10 per copy. You are open 365 days per year. A copier can make up to 80,000 copies per year. (a) Given these assumptions, what level of daily demand will enable you to break even? (b) Calculate the annual profits for specified in this template) daily demands and graph them. Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Copies per copier per year Daily demand (trial value) Total (i.e., annual) demand Copies made Total cost Total revenue Total profit Daily demand Profit 50 75 1001 125 150 175 200 225 250 275
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
