Find annual profit for each of the given combinations

Assignment Help Operation Management

Reference no: EM131893274

Question: 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. 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.

b. If you rent three copiers, what daily demand for copies will allow you to break even. (I need to understand how to input this data into excel and come up with the right numbers). I know this question has been asked on here but none of the answers explain how to make a two-way data table in excel for part a, which is what I need to do)

Reference no: EM131893274

Questions Cloud

Hired as consultant for pristine urban-tech zither : You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ), manufacturers of fine zithers. T

How have agreements and geographic proximity played a role : What do you think of Walmart's strategy in Mexico and Central America, and how have agreements and geographic proximity played a role in its success?

What is the irr of investment : What is the IRR of this investment?

What is the required rate of return on this stock : The dividend growth rate is expected to remain constant at the current level. What is the required rate of return on this stock?

Find annual profit for each of the given combinations : 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.

Enter the annual equivalent worth of the machine : Enter the annual equivalent worth of the machine that is the best alternative if the interest rate is 13.3%.

What is the annual cost of ordering and holding inventory : Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation.

Build a spreadsheet model for the food truck shop : We are thinking of opening a food truck to make and serve fried meat pies. It costs us $5000 to rent a fryer for a year. Ingredients and labor are estimated.

Why is cancelled recourse debt treated as income : Why is cancelled recourse debt treated as income? Calculate the current yield and show the formula you use.

User Account

All Pages