Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Equations For Engineers

Authors: Wei Chau Xie

1st Edition

0511771037, 9780511771033

More Books

Students also viewed these Mathematics questions

Question

Term project write on "Operations management of Amazon"

Answered: 1 week ago