Purchases Budget Tiger Drug Store carries a variety of health and beauty aids, including 500-count bottles of vitamins. The sales budget for vitamins for the first six months of the year is presented below. Unit Sales Dollar Sales January 200 $1,800 February 190 1,710 March 210 1,890 April 220 1,980 May 240 2,160 June 230 2,070 The owner of Tiger Drug believes that ending inventories should be sufficient to cover 10 percent of the next month’s projected sales. On January 1, 24 bottles of vitamins were in inventory. Required: Question Content Area 1. Prepare a merchandise purchases budget in bottles of vitamins for as many months as you can. Tiger Drug StoreMerchandise Purchases Budget January February March April May Unit sales fill in the blank fe8290f72fd6f81_1 fill in the blank fe8290f72fd6f81_2 fill in the blank fe8290f72fd6f81_3 fill in the blank fe8290f72fd6f81_4 fill in the blank fe8290f72fd6f81_5 Desired EI fill in the blank fe8290f72fd6f81_6 fill in the blank fe8290f72fd6f81_7 fill in the blank fe8290f72fd6f81_8 fill in the blank fe8290f72fd6f81_9 fill in the blank fe8290f72fd6f81_10 Total needed fill in the blank fe8290f72fd6f81_11 fill in the blank fe8290f72fd6f81_12 fill in the blank fe8290f72fd6f81_13 fill in the blank fe8290f72fd6f81_14 fill in the blank fe8290f72fd6f81_15 Less: BI fill in the blank fe8290f72fd6f81_16 fill in the blank fe8290f72fd6f81_17 fill in the blank fe8290f72fd6f81_18 fill in the blank fe8290f72fd6f81_19 fill in the blank fe8290f72fd6f81_20 Unit purchases fill in the blank fe8290f72fd6f81_21 fill in the blank fe8290f72fd6f81_22 fill in the blank fe8290f72fd6f81_23 fill in the blank fe8290f72fd6f81_24 fill in the blank fe8290f72fd6f81_25 Question Content Area 2. If vitamins are priced at cost plus 80 percent, what is the dollar cost of purchases for each month of your purchases budget? January $fill in the blank 6b5568076058fe0_1 February fill in the blank 6b5568076058fe0_2 March fill in the blank 6b5568076058fe0_3 April fill in the blank 6b5568076058fe0_4 May fill in the blank 6b5568076058fe0_5
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.
Purchases Budget
Tiger Drug Store carries a variety of health and beauty aids, including 500-count bottles of vitamins. The sales budget for vitamins for the first six months of the year is presented below.
Unit Sales | Dollar Sales | |
January | 200 | $1,800 |
February | 190 | 1,710 |
March | 210 | 1,890 |
April | 220 | 1,980 |
May | 240 | 2,160 |
June | 230 | 2,070 |
The owner of Tiger Drug believes that ending inventories should be sufficient to cover 10 percent of the next month’s projected sales. On January 1, 24 bottles of vitamins were in inventory.
Required:
Question Content Area
1. Prepare a merchandise purchases budget in bottles of vitamins for as many months as you can.
January | February | March | April | May | |
---|---|---|---|---|---|
Unit sales | fill in the blank fe8290f72fd6f81_1 | fill in the blank fe8290f72fd6f81_2 | fill in the blank fe8290f72fd6f81_3 | fill in the blank fe8290f72fd6f81_4 | fill in the blank fe8290f72fd6f81_5 |
Desired EI | fill in the blank fe8290f72fd6f81_6 | fill in the blank fe8290f72fd6f81_7 | fill in the blank fe8290f72fd6f81_8 | fill in the blank fe8290f72fd6f81_9 | fill in the blank fe8290f72fd6f81_10 |
Total needed | fill in the blank fe8290f72fd6f81_11 | fill in the blank fe8290f72fd6f81_12 | fill in the blank fe8290f72fd6f81_13 | fill in the blank fe8290f72fd6f81_14 | fill in the blank fe8290f72fd6f81_15 |
Less: BI | fill in the blank fe8290f72fd6f81_16 | fill in the blank fe8290f72fd6f81_17 | fill in the blank fe8290f72fd6f81_18 | fill in the blank fe8290f72fd6f81_19 | fill in the blank fe8290f72fd6f81_20 |
Unit purchases | fill in the blank fe8290f72fd6f81_21 | fill in the blank fe8290f72fd6f81_22 | fill in the blank fe8290f72fd6f81_23 | fill in the blank fe8290f72fd6f81_24 | fill in the blank fe8290f72fd6f81_25 |
Question Content Area
2. If vitamins are priced at cost plus 80 percent, what is the dollar cost of purchases for each month of your purchases budget?
January | $fill in the blank 6b5568076058fe0_1 |
February | fill in the blank 6b5568076058fe0_2 |
March | fill in the blank 6b5568076058fe0_3 |
April | fill in the blank 6b5568076058fe0_4 |
May | fill in the blank 6b5568076058fe0_5 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps