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 180 $1,620 February 170 1,530 March 190 1,710 April 200 1,800 May 220 1,980 June 210 1,890 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, 23 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 83526ff88046f84_1 fill in the blank 83526ff88046f84_2 fill in the blank 83526ff88046f84_3 fill in the blank 83526ff88046f84_4 fill in the blank 83526ff88046f84_5 Desired EI fill in the blank 83526ff88046f84_6 fill in the blank 83526ff88046f84_7 fill in the blank 83526ff88046f84_8 fill in the blank 83526ff88046f84_9 fill in the blank 83526ff88046f84_10 Total needed fill in the blank 83526ff88046f84_11 fill in the blank 83526ff88046f84_12 fill in the blank 83526ff88046f84_13 fill in the blank 83526ff88046f84_14 fill in the blank 83526ff88046f84_15 Less: BI fill in the blank 83526ff88046f84_16 fill in the blank 83526ff88046f84_17 fill in the blank 83526ff88046f84_18 fill in the blank 83526ff88046f84_19 fill in the blank 83526ff88046f84_20 Unit purchases fill in the blank 83526ff88046f84_21 fill in the blank 83526ff88046f84_22 fill in the blank 83526ff88046f84_23 fill in the blank 83526ff88046f84_24 fill in the blank 83526ff88046f84_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 0b7714060ffff88_1 February fill in the blank 0b7714060ffff88_2 March fill in the blank 0b7714060ffff88_3 April fill in the blank 0b7714060ffff88_4 May fill in the blank 0b7714060ffff88_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.
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 | 180 | $1,620 |
February | 170 | 1,530 |
March | 190 | 1,710 |
April | 200 | 1,800 |
May | 220 | 1,980 |
June | 210 | 1,890 |
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, 23 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 83526ff88046f84_1 | fill in the blank 83526ff88046f84_2 | fill in the blank 83526ff88046f84_3 | fill in the blank 83526ff88046f84_4 | fill in the blank 83526ff88046f84_5 |
Desired EI | fill in the blank 83526ff88046f84_6 | fill in the blank 83526ff88046f84_7 | fill in the blank 83526ff88046f84_8 | fill in the blank 83526ff88046f84_9 | fill in the blank 83526ff88046f84_10 |
Total needed | fill in the blank 83526ff88046f84_11 | fill in the blank 83526ff88046f84_12 | fill in the blank 83526ff88046f84_13 | fill in the blank 83526ff88046f84_14 | fill in the blank 83526ff88046f84_15 |
Less: BI | fill in the blank 83526ff88046f84_16 | fill in the blank 83526ff88046f84_17 | fill in the blank 83526ff88046f84_18 | fill in the blank 83526ff88046f84_19 | fill in the blank 83526ff88046f84_20 |
Unit purchases | fill in the blank 83526ff88046f84_21 | fill in the blank 83526ff88046f84_22 | fill in the blank 83526ff88046f84_23 | fill in the blank 83526ff88046f84_24 | fill in the blank 83526ff88046f84_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 0b7714060ffff88_1 |
February | fill in the blank 0b7714060ffff88_2 |
March | fill in the blank 0b7714060ffff88_3 |
April | fill in the blank 0b7714060ffff88_4 |
May | fill in the blank 0b7714060ffff88_5 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps