L Incorporated provided the following estimated sales data in the first five months of 2021: Month Estimated Sales (units) January 15,000 February ??? March 16,000 April ??? May 18,000 The desired ending inventory of finished goods is 20% of next month’s expected sales. Budgeted production for the month of February and April are 16,600 and 18,640 respectively. Each unit costs 120 to manufacture and is sold to yield gross profit of 25% based on cost. All sales are made on account. 20% is collected in the month of sale; 30% of the balance is collected in the following month, another 40% is collected two months after the month of sale while the rest are collected three months after the month of sale. Ending finished goods inventory in March shall be valued at
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.
L Incorporated provided the following estimated sales data in the first five months of 2021:
Month |
Estimated Sales (units) |
January |
15,000 |
February |
??? |
March |
16,000 |
April |
??? |
May |
18,000 |
The desired ending inventory of finished goods is 20% of next month’s expected sales. Budgeted production for the month of February and April are 16,600 and 18,640 respectively. Each unit costs 120 to manufacture and is sold to yield gross profit of 25% based on cost. All sales are made on account. 20% is collected in the month of sale; 30% of the balance is collected in the following month, another 40% is collected two months after the month of sale while the rest are collected three months after the month of sale. Ending finished goods inventory in March shall be valued at
Step by step
Solved in 2 steps with 1 images