Question

In: Accounting

Budgeted Sales: September October November December January 280,000 300,000 320,000 360,000 200,000 Planning Assumptions: 25% of...

Budgeted Sales:

September October November December January
280,000 300,000 320,000 360,000 200,000

Planning Assumptions:
25% of all Sales are cash. Accounts receivable are collected 60% in the month of sale, 30% in the next month, and with the final 10% in the third month.

Cost of Goods sold is 40% of sales. Inventory is purchased in the month prior to the sale, 70% is paid in the month of acquisition and 30% is paid the next month.

Operating Expenses:

Salaries 60,000
Depreciation 10,000
Rent 20,000
Utilities 6,000
Other 5,000

Commissions 2% of prior month's sales.
Supplies 1% current month Cost of Goods sold.

What is the 12/31 budgeted Accounts Receivable?
What is the budgeted balance for Accounts Payable at 12/31 for Inventory purchases?
What is the budgeted amount of Operating Expenses for December?

I am so confused, and I can't find how to figure these out in my textbook

Solutions

Expert Solution

Budgeted Accounts Receivable = $108000+24000 = $132000
From December Sales = $360000 x 75% x 40% = $108000
From November Sales = $320000 x 75% x 10% = $24000

Budgeted Accounts Payable = $200000 x 40% x 30% = $24000

Budgeted Operating Expenses

December
Salaries $           60,000
Depreciation $           10,000
Rent $           20,000
Utilities $             6,000
Other $             5,000
Commissions $             6,400 =320000*2%
Supplies $             1,440 =360000*40%*1%
Total Operating Expenses $       1,08,840

Related Solutions

Data regarding VeeLanceCorporation store's operations follow: •Sales are budgeted at $340,000 for November, $360,000 for December,...
Data regarding VeeLanceCorporation store's operations follow: •Sales are budgeted at $340,000 for November, $360,000 for December, and $350,000 for January. •Collections are expected to be 75% in the month of sale and 25% in the month following the sale. •The cost of goods sold is 71% of sales. •The the company desires an ending merchandise inventory equal to 75% of the cost of goods sold in the following month. •Payment for merchandise is made in the month following the purchase....
The budgeted sales for Milton Machine, Inc. are shown below: August............................$12,000 September......................$10,000 October..........................$20,000 November...................... $15,000 December.........................
The budgeted sales for Milton Machine, Inc. are shown below: August............................$12,000 September......................$10,000 October..........................$20,000 November...................... $15,000 December.........................$9,000 From past experience, the company has collected 20% of the cash in the month of the sale, 50% in the month after the sale, and 30% two months after the sale occurred. Prepare a schedule of expected cash collections from sales, by month and in total for the fourth quarter of the year.
Budgeted sales in Acer Corporation over the next four months are given below: September October November...
Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted Sales $140,000 $150,000 $170,000 $130,000 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour per unit 1.79 1.75 1.70 1.65 1.60 Direct manufacturing labour rate per unit $15.75 $16.00 $16.50 $17.50 $17.50 Ending inventory required is the next month sales , plus one half the following months sales The ending inventory in august was 15000 units Each employee is required to contributed to canada pension plan in the order of 4.9% of wages, this is matched by the...
Month May June July August September October November December January Sales 350 350 250 250 350...
Month May June July August September October November December January Sales 350 350 250 250 350 550 650 750 650 Collections month 0: 80%*95% month -1: 15% month -2: 5% Payments Purchase - 70% of next month sales Purchase payment - 50% of current month purchase Purchase payment - 50% of last month purchase Lease payment 10 10 10 10 10 10 construction 0 0 0 60 0 0 wages 30 30 40 50 70 80 other 5 5 5...
Seager Company budgeted the following credit sales during the current year: September, $100,000; October, $120,000; November,...
Seager Company budgeted the following credit sales during the current year: September, $100,000; October, $120,000; November, $110,000; December, $111,000. Experience has shown that cash from credit sales is received as follows: 10% in the month of sale, 60% in the first month after sale, 25% in the second month after sale, and 5% is uncollectible. How much cash should Seager Co. expect to collect in November from all current and past credit sales. (1 point). Check: Cash collected in November...
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020...
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020 Tonnes Supply, total 52,295 56,466 57,389 56,675 57,238 Beginning stocks 39,478 41,949 44,234 42,674 42,274 Production 12,407 13,808 12,474 13,388 14,738 Imports 410 709 680 613 226 Ending stocks 41,949 44,234 42,674 42,274 42,660 Disappearance, total 10,346 12,232 14,714 14,401 14,578 Exports 121 256 367 191 487 Domestic disappearance 10,226 11,976 14,347 14,209 14,091 Cheddar cheese, total Supply and disposition2 September 2019 October 2019...
The Sun Pacific Company budgeted the following sales: July                 200,000 August            210,000 September
The Sun Pacific Company budgeted the following sales: July                 200,000 August            210,000 September      190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July                 100,000 August            105,000 September      95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 80,000 $ 100,000 $ 60,000 Credit sales 240,000 360,000 180,000 Total sales $ 320,000 $ 460,000 $ 240,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 180,000 $ 160,000 $ 100,000 Credit sales 360,000 500,000 260,000 Total sales $ 540,000 $ 660,000 $ 360,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT