Question

Purchases Budget Tiger Drug Store carries a variety of health and beauty aids, including 500-count bottles...

  1. 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 160         $1,440        
    February 150         1,350        
    March 170         1,530        
    April 180         1,620        
    May 200         1,800        
    June 190         1,710        

    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, 21 bottles of vitamins were in inventory.

    Required:

    1. Prepare a merchandise purchases budget in bottles of vitamins for as many months as you can.

    Tiger Drug Store
    Merchandise Purchases Budget
    January February March April May
    Unit sales
    Desired EI
    Total needed
    Less: BI
    Unit purchases

    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 $
    February   
    March   
    April   
    May   

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 140,000 April 200,000 February 140,000 May 160,000 March 200,000 June 220,000 Beginning inventory for 2010 is 60,000 units. The budgeted inventory at the end of a month is 30 percent of units to be sold the following month. Purchase price per unit is $4. Prepare a purchases budget in units and...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 140,000 April 200,000 February 140,000 May 160,000 March 200,000 June 220,000 Beginning inventory for 2010 is 60,000 units. The budgeted inventory at the end of a month is 30 percent of units to be sold the following month. Purchase price per unit is $4. Prepare a purchases budget in units and...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 130,000 April 190,000 February 160,000 May 190,000 March 190,000 June 230,000 Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 20 percent of units to be sold the following month. Purchase price per unit is $3. Prepare a purchases budget in units and...
Exercise 13-32 (Algo) Estimate Purchases and Cash Disbursements (LO 13-4, 5) Midland Company buys tiles and...
Exercise 13-32 (Algo) Estimate Purchases and Cash Disbursements (LO 13-4, 5) Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles needed for three months’ sales. The tiles cost $1.00 each and must be paid for in cash. The company has 28,000 tiles in stock. Sales estimates, based on contracts received,...
3.   Schedule 3: Direct materials purchases budget (Assumes May sales equal April sales in units)                         &n
3.   Schedule 3: Direct materials purchases budget (Assumes May sales equal April sales in units)                                                                       January                                        February                                                                     Part K29            Part C30            Part K29            Part C30       Units produced...............          11,200                11,200                11,000                11,000       Dir. mat. per unit............     ×            2           ×            3           ×             2           ×           3            Production needs......          22,400                33,600                22,000                33,000       Desired EI.........................          6,600                9,900                 8,160           12,240            Total needed..................
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 47,000 Accounts receivable 205,600 Inventory 58,800 Buildings and equipment (net) 357,000 Accounts payable $ 87,225 Common stock 500,000 Retained earnings 81,175 $ 668,400 $ 668,400 Actual sales...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,000 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$120,000 April ​$280,000 July ​$200,000 February   140,000 May   275,000 August   200,000 March   170,000 June   200,000 ​(Click on the icon located on the​ top-right corner of the data table above in order to copy its contents into a spreadsheet.​) PrintDone . Lewis collects 30 percent of its sales in the month of the​ sale, 50 percent in the month following...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....