80.2K

Verified Solution

Link Copied!

XYZcom

Profit and loss

1st July 20xx to 30 June 20xx+1

Answer bellow

Profit and lossXYZcom

1st July 20xx+1 to 30 June 20xx+2

	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Total
Income
Product 1
Product 2
Product 3
Product 4
Total Income
Cost of sales
Product 1
Product 2
Product 3
Product 4
Total Cost of sales
Gross Profit
Expenses
Fixed costs
Cleaning
Bank fees
Insurance
Rent
Electricity
Printing, stationery, office
Salaries management
Variable costs
Cartage & freight
Salary and wage on costs
Wages product 1
Wages product 2
Wages product 3
Wages product 4
Total Expenses
Operating Profit

Project 2 You work for XYZcom. Prepare an operational budget for the next financial year using the Profit and Loss statement for the year just past Use the following assumptions: 1. Cartage and freight are 10% of income. 2. Cost of sales is 20% of income. 3. You only employ casual staff for production and wages per product are 20% of income for that product. 4. Wages on cost (superannuation, payroll tax, workcover etc) is 15% of production and management salaries). 5. Product 1 will decrease in sales from 1 January by 20%. 6. Product 2 will decrease in sales from 1 January by 10%. 7. Product 3 will increase in sales in sales from 1 July by 30%. 8. Product 4 will increase in sales from 1 January by 50%. Jul Aus Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Income Product 1 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5.000 $5,000 $5,000 $60,000 Product 2 $10.000 $10.000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10.000 $10,000 $120,000 Product 3 $8,000 $8.000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8.000 $8,000 $8.000 $96,000 Product 4 $20.000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $240,000 Total Income $43.000 543.000 $43.000 $43.000 $43,000 $43,000 $43,000 $43,000 $43,000 $43.000 $43.000 $43.000 $516,000 Cost of sales Product 1 $1,000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1.000 $12,000 Product 2 $2.000 $2.000 $2,000 $2.000 $2,000 $2,000 $2,000 $2,000 $2,000 $2.000 $2.000 $2,000 $24,000 Product 3 $1,600 $1,600 $1,600 $1.600 $1,600 $1,600 $1,600 $1,600 $1,600 $1.600 $1.600 $1,600 $19,200 Product $4,000 $4,000 $4,000 $4.000 $4,000 $4,000 $4,000 $4,000 $4,000 $4.000 $4,000 $4,000 $48,000 $8.600 58.600 $8,600 $8.600 $8,600 $8,600 $8,600 58.600 $8,600 58.600 $8.600 Total Cost of sales $8,600 S103,200 Gross Profit $34.400 $34.400 $34,400 $34,400 $34,400 $34,400 $34,400 $34,400 $34,400 $34.400 $34.400 $34,400 $412,800 Expenses Fixed costs Cleaning $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6.000 Bank fees $250 S250 $250 $250 $250 $250 $250 S250 $250 S250 $250 $250 $3,000 Insurance $1.000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1,000 $12,000 Rent 55.000 $5.000 $5,000 $5.000 $5,000 $5,000 $5,000 $5,000 $5,000 $5.000 $5.000 $5.000 $60,000 Electricity a gas $1.000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1.000 $12.000 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 Printing stationery, office $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 Salaries management $4,000 $4.000 $4,000 $48,000 Variable costs 54.300 $4.300 $4.300 $4,300 $4,300 $4,300 $4,300 $4,300 $1,300 $4,300 $4.300 $4.300 $4.300 $51,600 Cartage 1 freight $1.890 $1,890 $1,890 $1.890 $1,890 $1,890 $1,890 $1,890 $1,890 $1.890 $1.890 $1,890 Salary and wage on costs $22.680 $1.890 $1,000 Wages product 1 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1,000 $1,000 $12,000 Wages product 2 $2.000 $2.000 $2.000 $2.000 $2,000 $2,000 $2,000 $2,000 $2,000 $2.000 $2.000 $2,000 $24,000 Wages product 3 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $19,200 Wages product 4 $4,000 $4.000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 54.000 $4.000 $4,000 $48,000 Total Expenses $26,740 $26.740 $26,740 $26,760 $26,740 $26,740 $26,740 $26,700 $26,740 $26,740 $26,740 $26,740 $26.740 $26,740 $320,880 $7.660 $7.660 $7,660 $7.660 $7.660 Operating Profit $7,660 $7,660 $7,660 $7,660 57.660 57.660 $7.660 $91,920 Project 2 You work for XYZcom. Prepare an operational budget for the next financial year using the Profit and Loss statement for the year just past Use the following assumptions: 1. Cartage and freight are 10% of income. 2. Cost of sales is 20% of income. 3. You only employ casual staff for production and wages per product are 20% of income for that product. 4. Wages on cost (superannuation, payroll tax, workcover etc) is 15% of production and management salaries). 5. Product 1 will decrease in sales from 1 January by 20%. 6. Product 2 will decrease in sales from 1 January by 10%. 7. Product 3 will increase in sales in sales from 1 July by 30%. 8. Product 4 will increase in sales from 1 January by 50%. Jul Aus Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Income Product 1 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5.000 $5,000 $5,000 $60,000 Product 2 $10.000 $10.000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10.000 $10,000 $120,000 Product 3 $8,000 $8.000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8.000 $8,000 $8.000 $96,000 Product 4 $20.000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $240,000 Total Income $43.000 543.000 $43.000 $43.000 $43,000 $43,000 $43,000 $43,000 $43,000 $43.000 $43.000 $43.000 $516,000 Cost of sales Product 1 $1,000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1.000 $12,000 Product 2 $2.000 $2.000 $2,000 $2.000 $2,000 $2,000 $2,000 $2,000 $2,000 $2.000 $2.000 $2,000 $24,000 Product 3 $1,600 $1,600 $1,600 $1.600 $1,600 $1,600 $1,600 $1,600 $1,600 $1.600 $1.600 $1,600 $19,200 Product $4,000 $4,000 $4,000 $4.000 $4,000 $4,000 $4,000 $4,000 $4,000 $4.000 $4,000 $4,000 $48,000 $8.600 58.600 $8,600 $8.600 $8,600 $8,600 $8,600 58.600 $8,600 58.600 $8.600 Total Cost of sales $8,600 S103,200 Gross Profit $34.400 $34.400 $34,400 $34,400 $34,400 $34,400 $34,400 $34,400 $34,400 $34.400 $34.400 $34,400 $412,800 Expenses Fixed costs Cleaning $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6.000 Bank fees $250 S250 $250 $250 $250 $250 $250 S250 $250 S250 $250 $250 $3,000 Insurance $1.000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1,000 $12,000 Rent 55.000 $5.000 $5,000 $5.000 $5,000 $5,000 $5,000 $5,000 $5,000 $5.000 $5.000 $5.000 $60,000 Electricity a gas $1.000 $1.000 $1,000 $1.000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1.000 $1.000 $12.000 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 Printing stationery, office $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 Salaries management $4,000 $4.000 $4,000 $48,000 Variable costs 54.300 $4.300 $4.300 $4,300 $4,300 $4,300 $4,300 $4,300 $1,300 $4,300 $4.300 $4.300 $4.300 $51,600 Cartage 1 freight $1.890 $1,890 $1,890 $1.890 $1,890 $1,890 $1,890 $1,890 $1,890 $1.890 $1.890 $1,890 Salary and wage on costs $22.680 $1.890 $1,000 Wages product 1 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1.000 $1,000 $1,000 $12,000 Wages product 2 $2.000 $2.000 $2.000 $2.000 $2,000 $2,000 $2,000 $2,000 $2,000 $2.000 $2.000 $2,000 $24,000 Wages product 3 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $19,200 Wages product 4 $4,000 $4.000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 54.000 $4.000 $4,000 $48,000 Total Expenses $26,740 $26.740 $26,740 $26,760 $26,740 $26,740 $26,740 $26,700 $26,740 $26,740 $26,740 $26,740 $26.740 $26,740 $320,880 $7.660 $7.660 $7,660 $7.660 $7.660 Operating Profit $7,660 $7,660 $7,660 $7,660 57.660 57.660 $7.660 $91,920

Answer & Explanation Solved by verified expert

See Answer