Question
In: Finance
The Sun Pacific Company budgeted the following sales: July 200,000 August
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
1.Accounts payable for the next period (October)
2.If the company purchase a machine with a cost of $30,000 in September, doeswill the company need a loan?
3.If the answer to 2 is yes, what will be the amount?
Solutions
Expert Solution
| Answer 1 | ||||||||
| Accounts payable for the next period (October) = Budgeted purchases for September * 30% = $95000 * 30% = $28,500 | ||||||||
| Answer 2 & 3 | ||||||||
| Cash Budget for July , August and September | ||||||||
| July | August | September | ||||||
| Receipts | ||||||||
| Sales Collection | ||||||||
| Cash | $120,000.00 | $126,000.00 | $114,000.00 | |||||
| May sales collection | $19,000.00 | |||||||
| June Sales Collection | $54,000.00 | $18,000.00 | ||||||
| July sales collection | $60,000.00 | $20,000.00 | ||||||
| August sales Collection | $63,000.00 | |||||||
| Total Receipts | $193,000.00 | $204,000.00 | $197,000.00 | |||||
| Payments | ||||||||
| Cash Purchase | $70,000.00 | $73,500.00 | $66,500.00 | |||||
| Credit purchase | $27,000.00 | $30,000.00 | $31,500.00 | |||||
| Direct Labour | $35,000.00 | $36,750.00 | $33,250.00 | |||||
| Selling Expenses | $16,000.00 | $16,800.00 | $15,200.00 | |||||
| Other fixed expenses | $7,000.00 | $7,000.00 | $7,000.00 | |||||
| Taxes | $25,000.00 | |||||||
| Dividend | $20,000.00 | |||||||
| Interest on loan | $1,000.00 | $630.00 | $436.80 | |||||
| Purchase of machine | $30,000.00 | |||||||
| Total Payments | $156,000.00 | $184,680.00 | $208,886.80 | |||||
| Cash Surplus | $37,000.00 | $19,320.00 | -$11,886.80 | |||||
| Add : Beginning Cash balance | $25,000.00 | $25,000.00 | $25,000.00 | |||||
| Total Cash Available | $62,000.00 | $44,320.00 | $13,113.20 | |||||
| Less : Loan repayment | $37,000.00 | $19,320.00 | $0.00 | |||||
| Add : Loan taken | $0.00 | $0.00 | $11,886.80 | |||||
| Ending Cash balance | $25,000.00 | $25,000.00 | $25,000.00 | |||||
| Yes , the company need a loan to purchase a machine in september. | ||||||||
| Amount of Loan = $11,886.80 | ||||||||
jeff jeffy answered 2 years agoRelated Solutions
The Sun Pacific Company budgeted the following sales: July 200,000 August
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...
The Sun Pacific Company budgeted the following sales: July 200,000 August
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...
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...
The Sun Pacific Company budgeted the following sales: July 210,000 August 220,000 September
The Sun Pacific Company budgeted the following sales:
July
210,000
August
220,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
110,000
August
115,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...
The Sun Pacific Company budgeted the following sales: July 210,000 August 220,000 September
The Sun Pacific Company budgeted the following sales:
July
210,000
August
220,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
110,000
August
115,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...
The Sun Pacific Company budgeted the following sales: July 210,000 August 220,000 September 190,000 Sales in...
The Sun Pacific Company budgeted the following sales: July
210,000 August 220,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 110,000 August 115,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...
Harrti Corporation has budgeted for the following sales: July $ 449,000 August $ 584,000 September $...
Harrti Corporation has budgeted for the following sales:
July $ 449,000
August $ 584,000
September $ 617,000
October $ 892,000
November $ 750,000
December $ 710,000
Sales are collected as follows: 15% in the month of sale; 65% in the month following the sale; and the remaining 20% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The
budgeted selling price per unit is $60. Budgeted unit sales for
June, July, August, and September are 8,900, 20,000, 22,000, and
23,000 units, respectively. All sales are on credit.
Forty
percent of credit sales are collected in the month of the sale and
60% in the following month.
The
ending finished goods inventory equals 20% of the following month’s
unit sales.
The
ending raw materials inventory equals 10% of the following month’s
raw materials production needs. Each unit of...
Company budgeted sales in units for the next four months as follows: July 7,000 units August...
Company budgeted sales in units for the next four months as
follows:
July
7,000 units
August
5,000 units
September
6,500 units
1. Prepare the sales budget for the
company knowing that each unit is sold for $50. (1 pt)
2. Past experience has shown that the
ending inventory for each month should be equal to 20% of the next
month's sales in units. The inventory in the beginning of July was
only 1,000 units, & the inventory on September 30...
Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales...
Question 4: Rodie Company has budgeted sales revenues as
follows:
Particulars
June
July
August
Credit Sales
$135,000
$145,000
$90,000
Cash Sales
$90,000
$255,000
$195,000
Total Sales
$225,000
$400,000
$285,000
Past experience indicates that 60% of the credit sales will be
collected in the month of sale and the remaining 40% will be
collected in the following month. Purchases of inventory are all on
credit and 50% is paid in the month of purchase and 50% in the
month following purchase....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The Coronavirus will obviously impact the economy of big organizations like FIFA or the NBA but...
- Question: what is the difference between rights of assertion and observation assertion. Include which financial statements...
- how to read a csv file in php and make a html table? I can't use...
- ABC Inc. is evaluating a project that will increase annual sales by $230,000 and annual cash...
- Identify the behavior, values, and consumption patterns from people in New York City versus Milan Italy.
- A stock has a required return of 10%, the risk-free rate is 4.5%, and the market...
- How do the media options available to advertisers vary in different parts of the world? (Choose...
ADVERTISEMENT