Question

Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It...

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 27,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six months:

January 11,700
February 17,300
March 13,000
April 13,500
May 10,200
June 6,900


Required:

a. & b. Estimate purchases (in units) and cash required to make purchases in January, February, and March.

Please show work.

Homework Answers

Answer #1

Ans:

Month January February March April May June
1 Estimated sales 11700 17300 13000 13500 10200 6900
2 Beginnig inventory 27000 28500 25500
3 Ending inventory (next 3 month sales) 43800 36700 30600
4 Purchase for the month(1+3-2) 28500 25500 18100
5 Total cost = 4*1$ 28500 25500 18100
January February March
Purchase in unit 28500 25500 18100
Cash Required to Purchase 28500 25500 18100


Hope This Helped ! Let Me Know In Case of Any Queries. Please ThumpsUp !

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
Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It...
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, are as follows for the next six months: January 12,900 February...
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,...
Khloe Company imports gift items from overseas and sells them to gift shops and department stores...
Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information: The October 31 balance in the cash account is $53,965. All sales are on account. Sales in September were $1,000,000 and in October were $1,290,000. November sales are expected to be $2,155,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 27 percent are collected in the month...
Webster Company has the following sales budget.       January            $200,000             February&nbsp
Webster Company has the following sales budget.       January            $200,000             February           $240,000             March               $300,000             April                  $360,000       Cost of sales is 70% of sales. Sales are collected 40% in the month of sale and 60% in the following month. Webster keeps inventory equal to double the coming month's budgeted sales requirements. It pays for purchases 80% in the month of purchase and 20% in the month after purchase. Inventory at the beginning of January is $190,000.   Webster...
Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and...
Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information: The October 31 balance in the cash account is $54,115. All sales are on account. Sales in September were $960,000 and in October were $1,340,000. November sales are expected to be $2,180,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 26 percent are collected in...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods sold is 76% of...
Managerial Accounting Case 2 McMurray & Sons is a retailer of stuffed animals.   All items in...
Managerial Accounting Case 2 McMurray & Sons is a retailer of stuffed animals.   All items in the store sell for the same $18 selling price. McMurray estimates that 25% of its sales are for cash and 75% are on account. Other information regarding the company's budgeted sales and collection of credit sales are as follows: Budgeted sales in units      Credit Sales Collection Pattern December           9,000 Collected in same month as sale 50% January           1,000 Collected 1 months...
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...
The PM Company has planned the following sales for the next three months: January February March...
The PM Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account (A/R). From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% The following additional information has been provided for March: Inventory purchases (70% paid...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master for the first quarter. a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances. ASSETS LIABILITIES AND EQUITY Cash $ 47,000 Accounts Payable $ 92,000 Accounts Receivable 224,000 Capital Stock 500,000 Inventory 60,000 Retained Earnings 109,000 Buildings and Equipment (net of depreciation) 370,000 TOTAL ASSETS...