Assignment Activity 2 The following budget was created at the beginning of the 2018/19 financial year. In November of 2018 you were informed that in January/February/March of 2019 there will be major road works in your area which will affect your customers and your business. The road works will be for 8 weeks (the last two weeks of January, the four weeks of February and the first two weeks of March). You need to make plans for this period and adjust your budget accordingly as you anticipate losing 25% of business for those eight weeks and 10% of business for the two weeks after the road works. Develop and present a new budget for January, February and March 2019 and indicate what changes you will make to keep the budget on track as much as you can. N.B. Remember to present your assignment in a clear and professional manner that would be suitable for use in a business. Omar Indian Restaurant Budget 2018/19 July Aug Sep Oct Nov Dec Jan Feb Mar April May June 2018/2019 Income Food Sales-din Food Sales (TA) Bew Sales (A) Bev Sales (NA) Total Expenses Food purchases Bev Purch (a) Bev Purch (NA) Wages Superannuation Rent Other Total Net profit $72,800.00 $93,600.00 $88,400.00 $83,200.00 $93,600.00 $114,400.00 $72,800.00 $78,000.00 $104,000.00 $93,600.00 $83,200.00 $62,400.00 $1,040,000.00 $20,384.00 $26,208.00 $24,752.00 $23,296.00 $26,208.00 $32,032.00 $20,384.00 $21,840.00 $29,120.00 $26,208.00 $23,296.00 $17,472.00 $291,200.00 $13,104.00 $19,848.00 $15,912.00 $14,476.00 $16,848.00 $20,592.00 $13,104.00 $14,040.00 $18,720.00 $16,848.00 $14,476.00 $11,232.00 $189,200.00 $5,824.00 $7,488.00 $7,072.00 $6,656.00 $7,488.00 $9,152.00 $5,824.00 $6,240.00 $8,320.00 $7,488.00 $6,656.00 $4,992.00 $83,200.00 $112,112.00 $144,144.00 $136,136.00 $127,628.00 $144,144.00 $176,176.00 $112,112.00 $120,120.00 $160,160.00 $144,144.00 $127,628.00 $96,096.00 $1,600,600.00 $28,000.00 $36,000.00 $34,000.00 $32,000.00 $36,000.00 $44,000.00 $28,000.00 $30,000.00 $40,000.00 $36,000.00 $32,000.00 $24,000.00 $400,000.00 $5,236.00 $6,732.00 $6,358.00 $5,984.00 $6,732.00 $8,228.00 $5,336.00 $5,610.00 $7,480.00 $6,732.00 $5,984.00 $4,488.00 $74,900.00 $2,093.00 $2,691.00 $2,541.00 $2,392.00 $2,691.00 $3,289.00 $2,093.00 $2,242.00 $2,990.00 $2,691.00 $2,392.00 $1,794.00 $29,899.00 $42,602.00 $54,774.00 $51,731.00 $48,688.00 $54,774.00 $66,946.00 $42,602.00 $45,645.00 $60,860.00 $54,774.00 $48,688.00 $36,516.00 $608,600.00 $3,833.00 $4,929.00 $4,655.00 $4,381.00 $4,929.00 $6,024.00 $4,047.00 $4,336.00 $5,477.00 $4,929.00 $4,381.00 $3,286.00 $55,207.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $8,666.00 $103,992.00 $9,450.00 $12,150.00 $11,475.00 $12,150.00 $12,150.00 $14,850.00 $9,450.00 $10,125.00 $13,500.00 $12,150.00 $12,150.00 $8,100.00 $137,700.00 $99,880.00 $125,942.00 $119,426.00 $125,942.00 $125,942.00 $152,003.00 $100,194.00 $106,624.00 $138,973.00 $125,942.00 $125,942.00 $86,850.00 $1,433,660.00 $12,232.00 $18,202.00 $16,710.00 $1,686.00 $18,202.00 $24,173.00 $11,918.00 $13,496.00 $21,187.00 $18,202.00 $1,686.00 $9,246.00 $166,940.00