Question

C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...

C.

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 is 35% of purchases

Selling Expenses are 8% of sales

Other Fixed Expenses are $7,000 monthly

Taxes of $25,000 will be paid in September

Dividends of $20,000 will be paid in August

Sun Pacific has a loan with $100,000 outstanding balance in June

Interest expenses are 1% of the last month outstanding balance

The firm cash policy is to maintain a $25,000 ending cash balance (the ending balance in June was $25,000). Excess should be used to repay loans.

REQUIRED CALCULATE

20. Cash Sales in August

21. Cash receipts in July

22. Cash receipts in September

23. Cash payments in August

24. Cash payments in September

25. Loan outstanding balance in September

26. Interest payment in August

27. Preliminary Cash balance in September

28. Accounts payable for the next period (October)

29. If the company purchase a machine with a cost of $30,000 in September, does the company will need a loan

30. If the answer to 29 is yes, what will be the amount?

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

As per policy, only four parts of a question are allowed to answer, so answering 20 - 24,

20. Cash Sales in August = Aug. sales * 60% = 210000 * 60% = $126000

21. Cash receipts in July = Sales * % of receipt = May (190000 * 10%) + June (180000 * 30%) = 19000 + 54000 = $73000

22. Cash receipts in September = July (200000 * 10%) + August (210000 * 30%) = $83000

23. Cash payments in August = Purchases (july 100000*30%) + Purchases (august 105000*70%) + D Labor (105000*35%) + Selling Expenses(210000*8%) + Fixed Exp. $7000 + Dividend $20000 + Interest (100000*1%) = $185050

24. Cash payments in September = Purchases (august 105000*30%) + Purchases (sept. 95000*70%) + D Labor (95000*35%) + Selling Expenses(190000*8%) + Fixed Exp. $7000 + Taxes $25000 + Interest (100000*1%) = $179450

==================

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Company B is a merchandising Company. Estimated sales for July, August, and September will be $200,000,...
Company B is a merchandising Company. Estimated sales for July, August, and September will be $200,000, $190,000, and $210,000, respectively. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The average gross profit ration is 60%. The company pays for 40% of its merchandise purchase in the month of purchase and the remaining 60% in the month following the purchase. 1. How much is the budgeted merchandise purchase in August? 2. How much is the...
Cash Budget Background: Sales for July, August, and September are expected to be $200,000, $210,000, and...
Cash Budget Background: Sales for July, August, and September are expected to be $200,000, $210,000, and $190,000, respectively, for Pasta Company. All sales are on account and are collected 50% in the month of the sale and 45% in the following month. The remaining 5% is determined to be uncollectible. Raw materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred. The cash balance at 8/1/2017 is $8750. Activities for the quarter...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000 Cash Sales 14,000 25,000 32,000 Total Sales $99,000 $105,000 $104,000 Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory purchases...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000...
Hector Company reports the following:      July August September Sales $ 15,000 $ 23,000 $ 27,000 Purchases 9,000 13,800 15,000 Payments for purchases are made in the month after purchase. Selling expenses are 16% of sales, administrative expenses are 11% of sales, and both are paid in the month of sale. Rent expense of $2,100 is paid monthly. Depreciation expense is $1,400 per month. Prepare a schedule of budgeted cash payments for August and September. HECTOR COMPANY Budgeted Cash Payments...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at...
Cave Hardware's forecasted sales for April, May, June, and July are $190,000, $210,000, $180,000, and $230,000,...
Cave Hardware's forecasted sales for April, May, June, and July are $190,000, $210,000, $180,000, and $230,000, respectively. Sales are 70% cash and 30% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 80% of sales and ending inventory is maintained at $35,000 plus 20% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78% in the following month. What are the...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
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....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT