PURCHASING BUDGET: | |||||
APRIL | MAY units | JUNE units | JULY | TOTAL | |
ESTI SALES | 200 | 860 | 700 | 740 | |
ADD:ESTI ENDING | 800 | 700 | 740 | 0 | |
TOTAL MERCHANDISE NEEDS | 1000 | 1560 | 1440 | 740 | |
LESS:BEGIN INVEN | 0 | 800 | 700 | 740 | |
MERCHANDISE TO BE PURCHASED | 1000 | 760 | 740 | 0 | |
PUR VALUE (in dollar) | 29000 | 22040 | 21460 | 72500 | |
DISBURSEMENT BUDGET: | |||||
APRIL | MAY | JUNE | JULY | TOTAL | |
APRIL PUR (DELIVERY) | 11600 | ||||
APRIL PUR (SALES) | 3480 | 13920 | |||
MAY PUR (DELIVERY) | 8816 | ||||
MAY PUR (SALES) | 1044 | 12180 | |||
JUNE PUR (DELIVERY) | 8584 | ||||
JUNE PUR (SALES) | 12876 | ||||
TOTAL PAYMENTS | 15080 | 23780 | 20764 | 12876 | 72500 |
Kealy's Vintage Books purchases vintage books a month in advance of planned sales. Vintage books are...
Learning Objective: Estimate Purchases and Disbursements Kealy's Vintage Books purchases vintage books a month in advance of planned sales. Vintage books are purchased from wholesalers for $29 each (on average), using financing to pay 40% of the purchase in the month of delivery and the remaining 60% in the month of the sale. Kealy purchased 1,000 books in April and has 800 books in stock at the end of the month. Estimated sales for May are 860 books, June are...
Learning Objective: Estimate Purchases and Disbursements Kealy's Vintage Books purchases vintage books a month in advance of planned sales. Vintage books are purchased from wholesalers for $29 each (on average), using financing to pay 40% of the purchase in the month of delivery and the remaining 60% in the month of the sale. Kealy purchased 1000 books in April and has 800 books in stock at the end of the month. Estimated sales for May are 860 books, June are...
Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six months of 2017 are as follows: Month Unit Sales Month Unit Sales January 155,000 April 240,000 February 185,000 May 205,000 March 225,000 June 265,000 Beginning inventory for 2017 is 35,000 units. The budgeted inventory at the end of a month is 40 percent of units to be sold the following month. Purchase price per unit is $5. Prepare a purchases budget in units and...
We were unable to transcribe this image4% of sales Variable: Sales commissions Fixed: Advertising Rent Salaries Utilities Insurance Depreciation $ 320,000 $ 30,000 $ 130,000 $ 13,000 $ 4,200 $ 26,000 Insurance is paid on an annual basis, in November of each year. The company plans to purchase $22,000 in new equipment during May and $52,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $24,000 each quarter, payable in the first month...
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $150,000 July $ 90,000 June 160,000 August 80,000 September 100,000 October 120,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...
QS 22-29A Merchandising: Computing purchases LO P4 Lexi Company forecasts unit sales of 1,200,000 in April, 1,290,000 in May, 350,000 in June, and 1,100,000 in July. Beginning inventory on April 1 is 380,000 units, and the company wants to have 30% of next month's sales in inventory at the end of each month. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget For April, May, and June April Next month's budgeted...
Garden Sales, Inc., sells garden supplies, Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 590,000 $ 790,000 $ 490,000 $390,000 413,000 553,000 343, 000273,000 177,000...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 720,000 $ 890,000 $ 600,000 $500,000 504,000 623,000 420,000 350,000 216,000...
managerial cost accounting, please help .. thank you
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 620,000 $ 810,000...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 670,000 $ 840,000 $ 550,000 $ 450,000 469,000 588,000 385,000 315,000...