1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
alina1380 [7]
3 years ago
12

The treasurer of Systems Company has accumulated the following budget information for the first two months of the coming year:Ma

rch AprilSales. $450,000 $520,000Manufacturing costs 290,000 350,000Selling and administrative expenses 41,400 46,400Capital additions 250,000 ---The company expects to sell about 35% of its merchandise for cash. Of sales on account, 80% are expected to be collected in full in the month of the sale and the remainder in the month following the sale. One-fourth of the manufacturing costs are expected to be paid in the month in which they are incurred and the other three-fourths in the following month. Depreciation, insurance, and property taxes represent $6,400 of the probable monthly selling and administrative expenses. Insurance is paid in February and a $40,000 installment on income taxes is expected to be paid in April. Of the remainder of the selling and administrative expenses, one-half are expected to be paid in the month in which they are incurred and the balance in the following month. Capital additions of $250,000 are expected to be paid in March.Current assets as of March 1 are composed of cash of $45,000 and accounts receivable of $51,000. Current liabilities as of March 1 are composed of accounts payable of $121,500 ($102,000 for materials purchases and $19,500 for operating expenses). Management desires to maintain a minimum cash balance of $20,000.Prepare a monthly cash budget for March and April.
Business
1 answer:
expeople1 [14]3 years ago
7 0

Answer:

March $6,000

April $134,400

Explanation:

Preparation of a monthly cash budget for March and April

SYSTEMS COMPANY CASH BUDGET FOR MARCH AND APRIL

March April

Estimated cash receipts from:

Cash sales $157,500 $182,000

($450,000*35%=$157,500)

($520,000*35%=$182,000)

Collections of accounts receivable

$285,000 $328,900

[$51,000+($450,000*65%*80%)=$285,000]

[($450,000*65%*20)+($520,000*65%*80%)=$328,900]

Total cash receipts $442,500 $510,900

($157,500+$285,000=$442,500)

($182,000+$328,900=$510,900)

Estimated cash payments for:

Manufacturing costs $174,500 $305,000

[$102,000+($290,000*1/4)=$174,500]

[($290,000*3/4)+($350,000*1/4=$305,000)]

Selling and administrative expenses $37,000 $37,500

[($41,400-$6,400)/2 + $19,500 $37,000]

[($46,400-$6,400)/2 +$19,500$37,500]

Capital additions $250,000 $0

Income taxes $0 $40,000

Total cash payments $461,500 $382,500

Cash increase (decrease) -$19,000 $128,400

($442,500-$461,500=-$19,000)

($510,900-$382,500=$128,400)

Cash balance at beginning of month $45,000 $26,000

Cash balance at end of month $26,000 $154,400

(-$19,000+$45,000=$26,000)

($128,400+$26,000=$154,400)

Minimum cash balance $20,000 $20,000

Excess (deficiency) $6,000 $134,400

($26,000-$20,000=$6,000)

($154,400-$20,000=$134,400)

Therefore The monthly cash budget for March and April will be :

March $6,000

April $134,400

You might be interested in
What is a foreign country that is currently being impacted financially due to the Coronavirus
Westkost [7]

Answer:

Macau

Explanation:

First, we need to understand that all countries are impacted financially due to the corona virus. It's predicted that Corona Virus will cause a loss of around $2.7 trillion in Global Economy.

That being said, some countries are impacted more than the others.

Especially those who rely on tourism and hospitality as their main economy. Macau is probably the one that got the hardest hit. Not only this country is located near China (where the virus originally came from) , tourism and hospitality accounted for around 43% of Macau's economy. Basically half of its  economic activity shut down due to the virus.

6 0
2 years ago
Read 2 more answers
Pizza Deluxe University is an in-house center and education facility that offers broad-based learning opportunities for employee
Fiesta28 [93]

Answer:

its very much difficut . I am sorry

3 0
2 years ago
An investment project has annual cash inflows of $3,900, $4,800, $6,000, and $5,200, for the next four years, respectively. The
Volgvan

Answer:

1.88 years

Explanation:

Payback period is the time in which a project returns back the initial investment.  Initial Investment is recovered within the first two annual Cash inflows.

Payback Period = 1+0.88 = 1.88 years

All the working are made in the MS Excel File attached with this answer, pleas find it.

Download xlsx
7 0
3 years ago
Read 2 more answers
Neha is writing a report comparing the profits of three fashion design houses What type of organizational method should she use?
Marta_Voda [28]

Answer:

b) Component

Explanation:

Since in the question it is mentioned that the neha has written a report in which the profits of three fashion design houses could be compared

So in this situation, the component organizational method could help for knowing the strategic and the operational information so that it would be easy for comparing the profits between these three fashion houses

Therefore the option b is correct

3 0
2 years ago
Mr. Jones is a successful entrepreneur. He is currently planning a new business venture, but he doesn’t have sufficient funds fo
NeTakaya

Answer:

C) using his family home as collateral for a loan

E) mortgaging his factory building

Explanation:

Mr. Jones property rights include his family home and his factory building, and he is taking loans using both of them as collateral.

A: If someone sells a house or an apartment, they transfer their property rights.

B: If his company issues shares, they are not getting a loan, they are increasing their equity.  

D: If someone withdraws money form a CD, they are not getting a loan.

4 0
3 years ago
Other questions:
  • According to the video, what are some things that Human Resources Managers do? Check all that apply
    8·1 answer
  • Suppose there is a policy debate regarding the United States’ imposing trade restrictions on imported steel rods:
    12·1 answer
  • Jasmine is the director of marketing for a chain of clothing stores. She's been given a set budget and needs to drive as many po
    11·1 answer
  • Higado Confectionery Corporation has a number of store locations throughout North America. In income statements segmented by sto
    5·1 answer
  • The supply of aged cheddar cheese is inelastic, and the supply of bread is elastic. Both goods are considered to be normal goods
    12·1 answer
  • The Fed promotes secrecy by not releasing the minutes of the FOMC meetings to Congress or the public immediately. Discuss the ef
    5·1 answer
  • Novak Express reports the following costs and expenses in June 2017 for its delivery service. Indirect materials $7,000 Drivers’
    10·1 answer
  • Give examples of how we do not recognize people as having these rights but make them conditional on success in the marketplace.
    10·1 answer
  • DeLong Corporation was organized on January 1, 2017. It is authorized to issue 13,000 shares of 8%, $100 par value preferred sto
    10·1 answer
  • Which firm is the oligopolist? Choose one: Firm A is in retail. It is one of the largest and most popular clothing stores in the
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!