Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Excel. Part B I need to fill in the table, some of it is just examples but unsure. Thanks

Question 1: You are considering opening a small copy shop. The cost of renting a copier for a year is $5000, and it costs $0.03 per copy to operate the copier. Fixed costs associated with running the store will amount to $400 per month. Your store will sell copies on average for $0.10, and it will be open 365 days a year. One copier can produce up to 100,000 copies a year. Hint: these are your assumptions that you must use to solve the following problems.

a. You need to determine the annual profit for one to five copiers rented and daily demands that are 500,1000, 1500, and 2000 copies per day. This means you have to find out the annual profit for each of these combinations of copiers rented and daily demand. [ 4 points]

b. Lets suppose that you were considering renting three copiers, how much daily demand would it take for you to break even?

image text in transcribedimage text in transcribedimage text in transcribed

BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 A4 A- A.AZ E.EE AH T AaBbDdEe AaBbCcDdE AaBb CcDdEe AaBbDdEe AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste B I Uabe Xx? A Normal Body Text List Paragraph No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane a) For daily demand of 500 per day No. of copier 2 3 4 Annual demand $182,500 $182,500 $182,500 $182,500 $182,500 Capacity $100,000 $200,000 $300,000 $400,000 $500,000 Fixed cost $5,000 $10,000 $15,000 $20,000 $25,000 Other fixed cost $4,800 $4,800 $4,800 $4,800 $4,800 Variable cost $3,000 $5.475 $5,475 $5,475 $5,475 Revenue and Profit Model Revenue $10,000 $18,250 $18,250 $18,250 $18,250 Total cost Profit-$2,800 -$2,025 $7,025 $12,025 -$17,025 For daily demand of 1000 per day No. of copier 1 2 3 Annual demand $365,000 $365,000 $365,000 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 Variable cost Plot Area $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit -$2,800 -$800 $1,200 4 5 $365,000 $365,000 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $10.950 $10,950 $4,800 $36,500 $36,500 $750 -$4,250 For daily demand of 1500 per day No. of copier 1 Annual demand $547,500 $547,500 $547,500 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 $4,800 Variable cost $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit-$2,800 -$800 $1,200 4. 5 $547,500 $547,500 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $12,000 $15,000 $40,000 $50,000 $3,200 $5,200 Page 2 of 10 1473 Words IX English O Focus + 121% BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 A4 A- A. E.EE A ! 1 AaBbDdEe AaBbCcDdEe AaBbCcDdE AaBbCeDdEe Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbceDde AaBb Paste B I Uabe X2 X2 . Normal No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane Fore daily demand of 2000 per day No. of copier 1 2 3 Annual demand $730,000 $730,000 $730,000 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 $4,800 Variable cost $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit -$2,800 -$800 $1,200 4 5 $730,000 $730,000 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $12,000 $15,000 $40,000 $50,000 $3,200 $5,200 | b) Breakeven for 3 copiers The daily demand for renting three copiers is 775 copies to reach breakeven Plot Area Excel output Show formulas (Used What-If Goal seek) Copier demand decision model Inputs Unit cost Fixed cost Annual renatal cost Monthly store rent Annual store cost Unit selling price Copier constraint Calendar days $0.03 $19,800 $5,000.00 $400.00 $4,800.00 $0.10 100,000.00 365 Decision variable Copier quantity 3 Uncertain quantity Page 3 of 10 1473 Words IX English Focus + 130% BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A E.EE A! T AaBbcDdEe AaBb CcDdEe AaBbCcDdEAaBbCcDdEe Normal Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbceDde AaBb Paste BIU abe X2 X2 A No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane b) Breakeven for 3 copiers The daily demand for renting three copiers is 775 copies to reach breakeven Excel output Show formulas (Used What-If Goal seek) Copier demand decision model Inputs $0.03 $19,800 Unit cost Fixed cost Annual renatal cost Monthly store rent Annual store cost Unit selling price Copier constraint Calendar days $5,000.00 $400.00 $4,800.00 $0.10 100,000.00 365 Decision variable Plot Area Copier quantity 3 Uncertain quantity Demand 500 Porfit model Annual production Revenue Cost Profit 182,500.00 $18,250.00 $25,275.00 -$ 7,025.00 Page 3 of 10 1473 Words IX English E FE Focus + 130% BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 A4 A- A.AZ E.EE AH T AaBbDdEe AaBbCcDdE AaBb CcDdEe AaBbDdEe AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste B I Uabe Xx? A Normal Body Text List Paragraph No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane a) For daily demand of 500 per day No. of copier 2 3 4 Annual demand $182,500 $182,500 $182,500 $182,500 $182,500 Capacity $100,000 $200,000 $300,000 $400,000 $500,000 Fixed cost $5,000 $10,000 $15,000 $20,000 $25,000 Other fixed cost $4,800 $4,800 $4,800 $4,800 $4,800 Variable cost $3,000 $5.475 $5,475 $5,475 $5,475 Revenue and Profit Model Revenue $10,000 $18,250 $18,250 $18,250 $18,250 Total cost Profit-$2,800 -$2,025 $7,025 $12,025 -$17,025 For daily demand of 1000 per day No. of copier 1 2 3 Annual demand $365,000 $365,000 $365,000 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 Variable cost Plot Area $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit -$2,800 -$800 $1,200 4 5 $365,000 $365,000 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $10.950 $10,950 $4,800 $36,500 $36,500 $750 -$4,250 For daily demand of 1500 per day No. of copier 1 Annual demand $547,500 $547,500 $547,500 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 $4,800 Variable cost $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit-$2,800 -$800 $1,200 4. 5 $547,500 $547,500 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $12,000 $15,000 $40,000 $50,000 $3,200 $5,200 Page 2 of 10 1473 Words IX English O Focus + 121% BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 A4 A- A. E.EE A ! 1 AaBbDdEe AaBbCcDdEe AaBbCcDdE AaBbCeDdEe Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbceDde AaBb Paste B I Uabe X2 X2 . Normal No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane Fore daily demand of 2000 per day No. of copier 1 2 3 Annual demand $730,000 $730,000 $730,000 Capacity $100,000 $200,000 $300,000 Fixed cost $5,000 $10,000 $15,000 Other fixed cost $4,800 $4,800 $4,800 Variable cost $3,000 $6,000 $9,000 Revenue and Profit Model Revenue $10,000 $20,000 $30,000 Total cost Profit -$2,800 -$800 $1,200 4 5 $730,000 $730,000 $400,000 $500,000 $20,000 $25,000 $4,800 $4,800 $12,000 $15,000 $40,000 $50,000 $3,200 $5,200 | b) Breakeven for 3 copiers The daily demand for renting three copiers is 775 copies to reach breakeven Plot Area Excel output Show formulas (Used What-If Goal seek) Copier demand decision model Inputs Unit cost Fixed cost Annual renatal cost Monthly store rent Annual store cost Unit selling price Copier constraint Calendar days $0.03 $19,800 $5,000.00 $400.00 $4,800.00 $0.10 100,000.00 365 Decision variable Copier quantity 3 Uncertain quantity Page 3 of 10 1473 Words IX English Focus + 130% BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A E.EE A! T AaBbcDdEe AaBb CcDdEe AaBbCcDdEAaBbCcDdEe Normal Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbceDde AaBb Paste BIU abe X2 X2 A No Spacing Table Paragr... Heading 1 Heading 2 Title Styles Pane b) Breakeven for 3 copiers The daily demand for renting three copiers is 775 copies to reach breakeven Excel output Show formulas (Used What-If Goal seek) Copier demand decision model Inputs $0.03 $19,800 Unit cost Fixed cost Annual renatal cost Monthly store rent Annual store cost Unit selling price Copier constraint Calendar days $5,000.00 $400.00 $4,800.00 $0.10 100,000.00 365 Decision variable Plot Area Copier quantity 3 Uncertain quantity Demand 500 Porfit model Annual production Revenue Cost Profit 182,500.00 $18,250.00 $25,275.00 -$ 7,025.00 Page 3 of 10 1473 Words IX English E FE Focus + 130%

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

Step: 3

blur-text-image

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

Auditing Basics

Authors: 3G E-Learning

1st Edition

1984624261, 978-1984624260

More Books

Students also viewed these Accounting questions

Question

D How will your group react to this revelation?

Answered: 1 week ago