Question

South Dakota Corporation is preparing its budgets for the upcoming quarter which includes October, November, and December 20x
SOUTH DAKOTA CORPORATION DATA FOR PREPARING MASTER BUDGET FOR MONTHS OF OCTOBER THROUGH DECEMBER 20X7 (1) Actual sales and pu
0 0
Add a comment Improve this question Transcribed image text
Answer #1
South Dakota Corporation
Cash Budget
Oct Nov Dec Total
Beginning Cash Balance 12000 44450 76900 12000
Add: Total Budgeted Cash Receipts 781200 876200 813125 2470525
Less: Payments for Purchases -555000 -607500 -582500 -1745000
Less: Variable Operating Expenses 15% of sales(1month later) -123750 -131250 -135000 -390000
Less: Fixed Expenses -70000 -70000 -70000 -210000
Less: Equipment Purchased -35000 -35000
Less: Dividends -25000 -25000
Closing Cash Balance 44450 76900 77525 77525

Working Notes:

South Dakota Corporation
Statement of collection from Debtors
Aug Sep Oct Nov Dec Total
Sales 75000 825000 875000 900000 800000 3475000
Type of Sale:
Cash 30% 22500 247500 262500 270000 240000 1042500
Credit 70% 52500 577500 612500 630000 560000 2432500
Collection of Receivables:
Same month 60% 31500 346500 367500 378000 336000 1459500
1 Month Later 25% 13125 144375 153125 157500 468125
2 Month Later 13% 6825 75075 79625 161525
Total Cash Receipts 54000 607125 781200 876200 813125 3131650


South Dakota Corporation
Statement of Payment of Purchases
Aug Sep Oct Nov Dec Total
Purchases 500000 600000 550000 625000 575000 2850000
Payment for purchases:
Same month 70% 350000 420000 385000 437500 402500 1995000
1 Month Later 20% 100000 120000 110000 125000 455000
2 Month Later 10% 50000 60000 55000 165000
Total Payment for purchases 350000 520000 555000 607500 582500 2615000
Add a comment
Know the answer?
Add Answer to:
South Dakota Corporation is preparing its budgets for the upcoming quarter which includes October, November, and...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 3) The following information pertains to Amigo Corporation: Month July August September October November December Sa...

    3) The following information pertains to Amigo Corporation: Month July August September October November December Sales $30,000 34,000 38,000 42,000 48,000 60,000 Purchases $10,000 12,000 14,000 16,000 18,000 20,000 Cash is collected from customers in the following manner: Month of sale 40% Month following sale 40% Two months following sale 20% • 60% of purchases are paid for in cash in the month of purchase, and the other 40% is paid the following month. Required: Complete the cash budget for...

  • Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...

    Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 32,000 22,000 22,000 42,000 October 82,000 62,000 December July August September November The selling price of the beach umbrellas is $12 per unit. Sales in June were 37,000 units. b. All sales are on account....

  • Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...

    Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units) 33,000 23,000 23,000 43,000 October 83,000 November 63,000 December July August September The selling price of the beach umbrellas is $10 per unit. Sales in June were 38,000 units b. All sales are on account....

  • Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...

    Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 44,000 October 84,000 November 64,000 December July August September 34,000 24,000 24,000 The selling price of the beach umbrellas is $12 per unit. Sales in June were 39,000 units. b. All sales are on account....

  • Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...

    Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July August September 31,000 October 71,000 November 51,000 December 21,000 11,000 11,000 The selling price of the beach umbrellas is $10 per unit. Sales in June were 26,000 units. b. All sales are on account....

  • 3) The following information pertains to Amigo Corporation:       Month    ...

    3) The following information pertains to Amigo Corporation:       Month                        Sales         Purchases       July                         $30,000             $10,000       August                      34,000               12,000       September                 38,000               14,000       October                     42,000               16,000       November                 48,000               18,000       December                  60,000               20,000 •    Cash is collected from customers in the following manner:       Month of sale                                        40%       Month following sale                             40%       Two months following sale                    20%       •    60% of purchases are paid for in cash in the month of purchase, and the other...

  • Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...

    Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):   July 33,000   October 23,000   August 73,000   November 13,000   September 53,000   December 13,000 The selling price of the beach umbrellas is $10 per unit. Sales in June were 28,000 units. b. All sales are on account....

  • The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October...

    The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October November December Sales $13,000 16,000 18,000 23,000 22,500 28,400 Purchases $6,000 5,700 7,500 8,300 9,200 10,100 Based on past experience cash is typically collected from customers in the following manner: Collected within 10 days of sale so receive a 10% cash discount 25% Collected after 10 days but in the month of sale 10% Collected in the month following the sale 40% Collected in...

  • Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...

    Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 35,500 October 25,500 August 81,000 November 12,000 September 50,000 December 12,500 The selling price of the beach umbrellas is $14 per unit. All sales are on account. Based on past experience, sales are collected in the...

  • Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...

    Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 34,000 August 78,000 September 47,000 October 24,000 November 10,500 December 11,000 The selling price of the beach umbrellas is $11 per unit. b. All sales are on account. Based on past experience, sales are collected...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT