Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You 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
You 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. A. Using a two way data table (copies across the top, daily demand along the side) for one to five copiers rented and daily demands of 500,1000,1500 and 2000 copies per day, find annual profit for each of these combinations of copiers rented and daily demand. B using goal seek. If you rent three copiers, what daily demand for copies will allow you to break even? C use a two way data table to get data for graph Copiers rented (trail value) Daily demand (trail value) Copies made Annual profit ** I'm having trouble with goal seek and selecting the values- I've been researching and still not understanding why I'm getting errors while inputting, I'm thinking I have a wrong number or wrong input somewhere along my excel page
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started