group member Sales budget wood material cost Dinning chairs(multiply by Coffee table(12.60) Kitchen(10.80) jan Direct material other cost lian Dinning chairs(2) Coffee table(5.40) Kitchen(9.20) Sales budget Annual direct budget jan 2700 1260 3240 300 540 2760 feb 3750 1800 9000 feb 3600 3150 3780 feb 400 1350 3220 march april 5000 4500 10500 6300 3780 4320 march april 700 1620 3680 march april 7200 4410 4860 8750 5400 12000 800 1890 4140 may 10000 6300 13500 may 6480 5040 5400 may 720 2160 4600 june 9000 7200 15000 june 6840 5670 5940 june 760 2430 5060 july 9500 8100 16500 july 5400 4410 6480 july 600 1890 5520 aug 7500 6300 18000 aug Annual fixed cost and income st aug 6300 3780 5400 700 1620 4600 sept 8750 5400 15000 sept Direct labour Dinning chairs(25) Coffee table(18) Kitchen(30) In this part of sales budget we have added all the other cost like wood materials, direct material cost as well as labour to the product so that we can get the value of the product 7200 5670 4860 sept 800 2430 4140 oct oct loct 10000 8100 13500 8100 5670 3240 900 2430 2760 nov 11250 8100 9000 nov 5040 3780 2700 nov 560 1620 2300 dec 7000 5400 7500 dec 3600 3150 1620 dec 400 1350 1380 5000 4500 4500 total total total 68760 49770 51840 170370 7640 21330 44160 Annual 95500 71100 144000 73130 310600
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Can you explain year by year sales what happened in the table in image?
Step by step
Solved in 2 steps