Question: Answer this in an excel spreadsheet and show the formulas. Please attach the excel sheet Problem 1. You are thinking of opening a small copy

Answer this in an excel spreadsheet and show the formulas. Please attach the excel sheet

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 a 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. (@) 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 100 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 blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Week 1 Data Assignment: Creating a Spreadsheet Model to Calculate Profit Objective : You will design a spreadsheet model to calculate profit for a small copier company. You will build on that model...

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

How to calculate Total Cost! Hello, I just need to calculate total cost in the tables below and then in my Excel Sheet. Could you help please and help with what the formula would be to calculate in...

Module 2 Data Assignment: Creating a Spreadsheet Model to Calculate Profit Objective: You will design a spreadsheet model to calculate profit for a small copier company. You will build on that model...

You are thinking of opening a small copy shop and rent a copier. It costs you $ 1 , 0 0 0 to rent a copier for a year and it costs you $ 0 . 0 3 per copy to operate the copier. Other fixed costs of...

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

You are thinking of opening a small copy shop. It costs $4,600 to rent a copier for a year, and it costs $0.06 per copy to operate the copier. Other fixed costs of running the store will amount to...

Please solve in EXCEL showing all formulas, thank you!! 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...

The unadjusted trial balance of Best Laundry at March 31, 2008, the end of the current fiscal year, is shown below. The data needed to determine year-end adjustments are as follows: a. Laundry...

(a) Let G = (V, E) be a connected bipartite undirected graph with V partitioned as V1 V2. Prove that if |V1| + |V2|, then G cannot have a Hamilton cycle. (b) Prove that if the graph G in part (a)...

Repaso M dulo 4 : Auditor a Interna 1 . Norma que se enfoca en los pasos a seguir: 2 2 0 0 2 . Norma que eval a los recursos humanos disponibles: 2 2 3 0 3 . Norma que establece qu tanto se va a...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...