Question

Young is a retailer of assorted baby products. The sales forecast for the coming months is:...

Young is a retailer of assorted baby products. The sales forecast for the coming months is:

Revenues
April $ 181,000
May $ 209,000
June $ 217,000
July $ 249,000
August $ 233,000



Young’s cost of sales averages 80% of revenues. The inventory policy is to carry 20% of next month’s sales needs. April 1 inventory will be as expected under the policy.

Young pays for purchases 70% in the month of purchase and 30% the following month. Accounts payable on April 1 is $24,400.

a. Prepare a purchases budget for as many months as is possible.

April May June July August
Sales
x 80% % % % % %
Cost of Sales
Ending Inv
Beginning Inv
Purchases




b. Prepare a cash payments budget for April through July.

April May June July
From This Month
From Last Month
Cash Payments

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
Ballan Inc. estimates its units sales for the coming months to be as follows:                  ...
Ballan Inc. estimates its units sales for the coming months to be as follows:                   March       280,000          April       260,000          May         250,000          June        230,000          July        240,000          August      225,000 Ballan maintains inventory at budgeted sales needs for the next month. March 1 inventory will be 248,000 units.      How much is the purchases for March? How much is the purchases for April?    How much is the purchases for May? How much is the purchases for June?...
Green lighting supply plans inventory levels (at cost) at the end of each month as follows:...
Green lighting supply plans inventory levels (at cost) at the end of each month as follows: May, $271,000; June, $226,000; July, $209,000; and August, $241,000. Sales are expected to be June, $449,000; July, $359,000; and August, $306,000. Cost of goods sold is 65% of sales. Purchases in April were $258,000 and in May they were $188,000. Payments for each month’s purchases are made as follows: 15% during that month, 70% the next month, and the final 15% the next month....
The Prince Albert Corporation has forecast the following sales for the first seven months of the...
The Prince Albert Corporation has forecast the following sales for the first seven months of the year.   January $28,000    May 28,000   February 30,000   June 34,000   March 32,000   July 36,000     April 38,000 Monthly material purchases are set equal to 30 percent of forecasted sales for the next month. Of the total material costs, 40 percent are paid in the month of purchase and 60 percent are paid in the following month. Labour costs will run $5,800 per month, and fixed overhead...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 640 720 670 760 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 128 units. Prepare a production budget for the months of April, May, and June. RUIZ CO. Production Budget For April, May, and June April May June Next month's budgeted sales...
2. The sales forecast for Moss follows: January = 5,000 February = 5,200 March = 5,600...
2. The sales forecast for Moss follows: January = 5,000 February = 5,200 March = 5,600 April = 6,000 May = 6,500 June = 7,000 July = 7,500 August = 7,000 (i). Company policy is to keep a target ending inventory of 20% of the next month’s sales. Prepare a production budget for April, may and June. (ii). Using the information from part (i), prepare a labor usage and purchases budget. It requires 3 hours at $18 per hour.
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 4,500 $ 810,000 May (actual) 2,200 396,000 June (budgeted) 7,500 1,350,000 July (budgeted) 5,000 900,000 August (budgeted) 3,600 648,000 All sales are on credit. Recent experience shows that 30% of credit sales is collected in the month of the sale, 40% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
Young Enterprises has budgeted sales in units for the next five months as follows: June: 4,600...
Young Enterprises has budgeted sales in units for the next five months as follows: June: 4,600 Units July: 7,200 Units August: 5,400 Units September: 6,800 Units October: 3,800 Units Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on May 31 fell short of this goal since it contained only 400 units. The company needs to prepare a Production Budget for the next five...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,580 May 3,890 June 4,540 July 4,110 August 3,990 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Ramos Co. provides the following sales forecast and production budget for the next four months: April...
Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 670 750 700 770 Budgeted production (units) 610 740 710 710 The company plans for finished goods inventory of 290 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 20% of next month’s production needs. Beginning direct...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT