Hello i would really aporeciate if someone can help me answer this problem as exact same excel spreadsheet. thank you so much

You are thinking about opening a small copy shop. It costs $5,000 to rent a copier for one 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. Use the attached Excel starter file to build your Excel model. D E F G H K L M Week 1 Homework Create your one-way data table in this box Inputs: Only change the orange cells Input Value Units Rent cost of copler 5,000 per year Oper cost 0.03 Sper copy Fixed cost 400 $ per month Revenue 0.10 $ per copy Copier Capacity 100,000 # per year Number of copiers 5 #copiers Dally demand copies per day Working Days 365 days 5 5 Model Calculations: Enter formulas in green cells Name Value Units Annual capacity coples per year Annual Demand coples per year Sales coples per year 3 Create your two-way data table in this box Capacity Demand 100,000 200,000 300.000 400.000 182,500 -2,800 -2,025 -7,025 -12,025 365,000 -2,800 -800 1,200 750 547,500 -2,800 -800 1,200 3,200 730,000 -2,800 -800 1,200 3,200 Revenues Rent cost Oper cost Fixed cost Profit 0 1 2 3 4 5 6 7 8 500,000 -17,025 -4.250 5,200 5,200 $ $ $ s S 10 11 32 33