25 Jan ou are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operat
- ou are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year.
- For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand.
- If you rent three copiers, what daily demand for copies will allow you to break even?
- Graph profit as a function of the number of copiers for a daily demand of 500 copies; for a daily demand of 2000 copies. Interpret your graphs.
Please check the attach excel. You must use the requested method to solve the problem with formula, graph or as requested.
Sheet1
| Copy shop |
| Inputs |
| Yearly rental cost |
| Other monthly fixed costs |
| Cost per copy |
| Charge per copy |
| Days per year |
| Months per year |
| Copies per copier per year |
| Profit model |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
| Part (a): Use a two-way data table (copies rented across the top, daily demand aloing the side) |
| Part (b): Use Goal Seek |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
| Part (c): Use a two-way data table to get data for graph |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.