You are the owner of a small business specializing in the restoration of oil paintings. You are trying to save enough money to lease a larger working space and thereby increase the amount of business that you can handle. You have enough orders to keep you busy for the next six months: July $ 5,500; August $9,450; September $8,300; October $4,600; November $7,700; December $6,300. Each month your overhead includes $1,000 for leasing your present workspace, 35% of each job for materials, 15% of each job for tools. The money remaining is your profit.
Present 3 spreadsheets:
#1 - Current financial situation for the next six months.
#2 - Financial situation if you decrease material expenditures to 25%
of each job
#3 - Financial situation if you decrease tool expenditures
to 10% of each job