Question

In: Finance

Archer Electronics is preparing its annual budget, and your department is working on the cash flow...

  1. Archer Electronics is preparing its annual budget, and your department is working on the cash flow budget. Here is selected information you have:

Description

June

July

August

Sales

$348,000

$438,000

$450,000

  1. The company makes 10% of its sales for cash and 90% on credit. Of the credit sales, 20% are collected in the month after the sale and 80% are collected two months after. The cash receipts for August are:

A.

Not enough information to solve the problem

B.

$326,000

C.

$374,400

D.

$366.000

E.

No answers are correct

Solutions

Expert Solution

Solution :

As per the information given in the question we have

a.10 % of the sales are made in cash and 90 % sales are made in credit

b.20 % Of the credit sales are collected in the month after the sale. Thus the sales amount collected in the month after the sale = ( 20 % * 90 % ) = 18 %

c.The balance of 80 % of credit sales are collected two months after the sale. Thus the sales amount collected two months after the sale = ( 80 % * 90 % ) = 72 %

We know that the month wise sales are as follows:

June = $ 348,000   ;    July = $ 438,000   ; August = $ 450,0000   ;

Thus from the above information it can be inferred that:

The amount of cash received in the month of August will be:

= 10 % of sales of August + 18 % of sales of July + 72 % of sales of June

Applying the available information we have the amount of cash received in the month of August as follows:

= ( $ 450,000 * 10 % ) + ( $ 438,000 * 18 % ) + ( $ 348,000 * 72 % )

= $ 45,000 + 78,840 + $ 250,560

= $ 374,400

Thus the cash receipts for August are = $ 374,400

The solution is option C. $ 374,400


Related Solutions

MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics...
MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics Company Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays...
Working capital: Winston Electronics reported the following information at its annual meetings. The company had cash...
Working capital: Winston Electronics reported the following information at its annual meetings. The company had cash and marketable securities worth $1,235,550, accounts payables worth $4,160,590, inventory of $7,122,030, accounts receivables of $3,488,900, notes payable worth $1,152,480, and other current assets of $122,410. What is the company’s net working capital?
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual...
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Year Prob = 0.3 Prob = 0.22 Prob = 0.48 0 –5000 –6000 –4000 1 1000 500 3100 2 1000 1500 1200 3 1000 2000 100 Determine the expected present worth of the following cash flow series if each series may be realized with the probability shown at the head of each column. Let i = 20% per year....
Assume that you are preparing a budget for your department or organization. Outline the steps you...
Assume that you are preparing a budget for your department or organization. Outline the steps you would take to prepare the budget, providing specific examples for each step.
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending...
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory Finished goods (units) 27,000 77,000 Raw material (grams) 57,000 47,000 Each unit of finished goods requires 2 grams of raw material. The company plans to sell 620,000 units during the year. How much of the raw material should the company purchase during the year?
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects available to the company. Assume the discount rate for all projects is 10 percent. Further, the company has only $22 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 7 –$...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects available to the company. Assume the discount rate for all projects is 9 percent. Further, the company has only $20 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 6 –$...
Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects. Assume the discount rate is 11 percent. Further, the company has only $33 million to invest in new projects this year. Cash Flows (in $ millions) Year L6 G5 Wi-Fi 0 −$ 10.0 −$ 23 −$ 33 1 14.0 21 31 2 10.5...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects available to the company. Assume the discount rate for all projects is 12 percent. Further, the company has only $25 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4 Wi-Fi 0 –$ 6 –$ 19...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects available to the company. Assume the discount rate for all projects is 11 percent. Further, the company has only $23 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 5 –$...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT