Question

In: Accounting

Q4Y4 Q1Y5 Q2Y5 Q3Y5 Q4Y5 Total Budgeted Sales (Actual for Q4Y4) 10000 11000 14000 15000 17000...

Q4Y4 Q1Y5 Q2Y5 Q3Y5 Q4Y5 Total
Budgeted Sales (Actual for Q4Y4) 10000 11000 14000 15000 17000 57000
Selling Price/per unit 9 9 9 9 9 9
Sale Collection
In quarter of sale 0.8
In following quarter 0.2
Desired ending finished goods inventory 2500 2200 2400 2100 2100
Raw Materials/per unit 5 5 5 5 5 5
Desired Ending raw material inventory Inventory 5000 8000 7000 6000 5000 5000
Raw material price/per unit 2 2 2 2 2 2
Accounts payable
In quarter of purchase 0.7
In following quarter 0.3
Q4Y4 raw material cost 100000

REQUIRED:

Sale Budget Year 5 Quarters
1 2 3 4

Year

Production Budget
Material Budget

Cash Receipts

Cash Payments

Solutions

Expert Solution

Sales budget

Q4Y4 Q1Y5 Q2Y5 Q3Y5 Q4Y5
Budgeted sales units 10000 11000 14000 15000 17000
Selling price per unit 9 9 9 9 9
Estimated sales revenue (currency) 90000 99000 126000 135000 153000


Production Budget

Q4Y4 Q1Y5 Q2Y5 Q3Y5 Q4Y5
Budgtd sales units 10000 11000 14000 15000 17000
Add: desired finished goods inventory 2500 2200 2400 2100 2100
12500 13200 16400 17100 19100
Less: Opening F.G inventory 0 2500 2200 2400 2100
Estimated units to be produced 12500 10700 14200 14700 17000

Materials Budget

Q4Y4 Q1y5 Q2Y5 Q3Y5 Q4Y5
Estimated F.G production units 12500 10700 14200 14700 17000
Raw materials per F.G. Unit 5 5 5 5 5
Total raw materials required (units) 62500 53500 71000 73500 85000
Add: desired ending R.M. Inventory 5000 8000 7000 6000 5000
67500 61500 78000 79500 90000
Less: Opening R.M. Inventory 0 5000 8000 7000 6000
Raw materials to be purchased 67500 56500 70000 72500 84000

Cash receipts budget

Q4Y4 Q1y5 Q2y5 Q3y5 Q4y5
Estimated sales revenue 90000 99000 126000 135000 153000
Cash collection in same qtr (80%) 72000 79200 100800 108000 122400
Cash collection in following qtr (20%) 18000 19800 25200 27000
Total cash collection in the quarter 72000 97200 120600 133200 149400

Cash payments budget:

Q4y4 Q1y5 Q2y5 Q3y5 Q4y5
Raw material units reqd 67500 56500 70000 72500 84000
R.M. Price per unit 2 2 2 2 2
Total raw material cost 135000 113000 140000 145000 168000
Acnts payable in same qtr (70%) 94500 79100 98000 101500 117600
Acnts payable in next qtr (30%) 40500 33900 42000 43500
Total estimated cash payments 94500 119600 131900 143500 161100

Related Solutions

         PX = $9500   PY = $10000   I = $15000   A = $170000   W =...
         PX = $9500   PY = $10000   I = $15000   A = $170000   W = 160 This function is:        Qs = 89830 -40PS +20PX +15PY +2I +.001A +10W 1. Use the above to calculate the arc price elasticity of demand between PS = $8000 and PS = $7000. The arc elasticity formula is: Ep= Q/P8 * P1+P1/Q1+Q2    2. Calculate the quantity demanded at each of the above prices and revenue that will result if the quantity...
Company MNO generates between 11000 and 15000 million dollars revenue per year. Suppose that the company's...
Company MNO generates between 11000 and 15000 million dollars revenue per year. Suppose that the company's revenue stays within this range. Use an interest rate of 9.75% per year compounded continuously. Fill in the blanks in the paragraph below, rounding your answers to the nearest tenth. The present value of MNO's revenue over a five year period is between _______________ and ______________ million dollars. Over a twenty-five year period, the present value falls between ____________ and _____________ million dollars
Amar Ltd furnishes the following information relating to budgeted sales and actual sales for the month...
Amar Ltd furnishes the following information relating to budgeted sales and actual sales for the month of March 2010. PRODUCT STANDARD UNITS STANDARD RATE (INR) ACTUAL UNITS ACTUAL RATE (INR) A 1200 15 880 18 B 800 20 880 20 C 2000 40 2640 38 calculate : (a) Sales price variance (b) Sales volume variance (c) Sales mix variance (d) Sales quantity variance
Williams Company sells women’s hats for $12 each. Actual and budgeted sales in units for nine...
Williams Company sells women’s hats for $12 each. Actual and budgeted sales in units for nine months are as follows: January (actual) ……….. 25,000 June (budget) …………. 50,000 February (actual) ……… 26,000 July (budget) ………….. 30,000 March (actual) ………… 40,000 August (budget) ………. 28,000 April (budget) ………… 65,000 September (budget) …… 25,000 May (budget) …………. 100,000 The company should have sufficient inventory on hand at the end of each month to supply 40% of the hats sold in the following...
The management estimates total sales for the period January through June based on actual sales from...
The management estimates total sales for the period January through June based on actual sales from the immediate past six months. The following assumptions are made: 1. The Sales were $150,000 in January 2018 and then the sales grew by 10% each month for the first five months (February to June). The sales are expected to grow by 5% each month thereafter. 2. 50% of the Sales are collected in the same month. 45% of the sales are collected in...
The management estimates total sales for the period January through June based on actual sales from...
The management estimates total sales for the period January through June based on actual sales from the immediate past six months. The following assumptions are made: 1. The Sales were $150,000 in January 2018 and then the sales grew by 10% each month for the first five months (February to June). The sales are expected to grow by 5% each month thereafter. 2. 50% of the Sales are collected in the same month. 45% of the sales are collected in...
TUMI Comparative Income Statement July, 20XX Budgeted Actual Sales (1) $       400,000 $   423,500 (1a) A....
TUMI Comparative Income Statement July, 20XX Budgeted Actual Sales (1) $       400,000 $   423,500 (1a) A. Less variable costs Variable cost of goods sold Direct materials (2)              100,000        108,000 B. Direct Labor (3)                60,000          70,000 C. Manufacturing Overhead (4)                80,000           240,000          81,000       259,000 D. Selling costs (5)              50,000         65,000 E. Contribution margin           110,000         99,500 Less Fixed costs Manufacturing overhead                52,000          53,000 F. Selling costs                10,000...
Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,000 $ 450,000 May (actual) 1,800 270,000 June (budgeted) 6,000 900,000 July (budgeted) 5,000 899,000 August (budgeted) 3,700 555,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 25% in the second month after the sale, and 5% proves to be uncollectible....
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 5,000 $ 800,000 May (actual) 2,000 320,000 June (budgeted) 4,500 720,000 July (budgeted) 3,500 719,000 August (budgeted) 3,900 624,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 26% in the second month after the sale, and 4% proves to be uncollectible....
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,500 $ 560,000 May (actual) 2,000 320,000 June (budgeted) 5,000 800,000 July (budgeted) 4,000 799,000 August (budgeted) 4,100 656,000 All sales are on credit. Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 25% in the second month after the sale, and 5% proves to be uncollectible....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT