All categories

3 years ago

Bombs Away Video Games Corporation has forecasted the following monthly sales:

Business

2 answers:

levacccp [35]3 years ago

7 0

Answer:

I have attached the excel file which shows the entire calculation of all the parts of your question. Majority of the numbers are linked so that its easy for you to understand. Key points before you look into file.

1) Number of units have derived by dividing revenue over sales price per unit which is $5

2) Production units are calculated by dividing total sales unit by 12 (as mentioned in the question)

3)Keep in mind that 80% of revenue will be received next month of the sales therefore also include in January sales receipt the 80% revenue of previous month

Explanation:

Download xlsx

svp [43]3 years ago

7 0

Answer:

please find the answer below

Explanation:

(a) Annual sales = $816, 000

Selling price = $5

Hence, number of units to be sold in a year = $816, 000 / $5

= 163, 200

Monthly production = 163, 200 / 12

= 13, 600 units

Month Production and inventory schedule:

Month Sales ($) Sales (units) Beginning inventory Production Ending inv

Jan 105, 000 21, 000 30, 000 13, 600 22, 600

Feb 98, 000 19, 600 22, 600 13, 600 16, 600

Mar 30, 000 6, 000 16, 600 13, 600 24, 200

Apr 30, 000 6, 000 24, 200 13, 600 31, 800

May 25, 000 5, 000 31, 800 13, 600 40, 400

Jun 40, 000 8, 000 40, 400 13, 600 46, 000

Jul 50, 000 10, 000 46, 000 13, 600 49, 600

Aug 50, 000 10, 000 49, 600 13, 600 53, 200

Sep 60, 000 12, 000 53, 200 13, 600 54, 800

Oct 90, 000 18, 000 54, 800 13, 600 50, 400

Nov 110, 000 22, 000 50, 400 13, 600 42, 000

Dec 128, 000 25, 600 42, 000 13, 600 30, 000

(b) Schedule of cash receipts:

Mon

Sales

‘000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Dec 100 80,000

Jan 105 21,000 84,000

Feb 98 19,600 78,400

Mar 30 6,000 24,000

Apr 30 6,000 24,000

May 25 5,000 20,000

Jun 40 8,000 32,000

Jul 50 10,000 40, 000

Aug 50 10, 000 40, 000

Sep 60 12, 000 48,000

Oct 90 18,000 72,000

Nov 110 22,000 88,000

Dec 128 25,600

Total 101,

000 103,

600 84,

400 30, 000 29,

000 28, 000 42, 000 50,

000 52, 000 66,

000 94,

000 113,

600

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Product-

ion

costs 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200 27, 200

Other

Costs 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000 50, 000

Total

costs 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200

(d) Cash Budget

Jan

Feb Mar Apr May Jun Jul Aug Sep Oct Nov

Dec

Opening

balance 5, 000 28, 800 55, 200 62, 000 14, 800 -32, 400 -80, 600 -129,

000 -165, 000 -192, 200 -217, 400 -200, 600

Cash

receipts 101, 000 103, 600 84, 000 30, 000 30, 000 29, 000 28, 000 42, 000 50, 000 52, 000 94, 000 113, 600

Cash

Payments 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200 77, 200

Closing

Balance 28, 800 55, 200 62, 000 14, 800 -32, 400 -80, 600 -129, 800 -165, 000 -192, 200 -217, 400 -200,600 -164, 200

Minimum

Balance

5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000

Bank loan 27, 400 75, 600 124, 800 160, 000 187,

200 214, 400 195, 600 159, 200

You might be interested in

Which of the following is NOT one of the four characteristics of IPOs that puzzle financial economists? Select one: a. The long-

Serhud [2]

Answer:

Explanation:

IPO , a synonym for initial public offering is a process of offering to the public new stock issuance through an underwriter.

IPO comes with a lot of benefit , nevertheless financial economist have some concern about it .

Of all the options given in the question , the long run of a new public company , (three to five years from the date of issue) being superior to the overall market returns is the only exception

7 0

3 years ago

19th century how successful were labor organizations in improving the working conditions for, and advancing the interests of ind

Alex Ar [27]

Answer:

19th century,labor organizations were not very successful in improving the working conditions and advancing the interest of industrial workers in united states.

<u>Explanation:</u>

Workers formed union.These unions give them immense power.These unions have a leader selected from among the workers only.Leader act as a representative of whole union.These unions can bargain on behalf of all the workers for providing them better working conditions,more wages,bonus.

They used strikes to force the employers to increase wages and provide better working conditions.These unions worked hard to stop child labor,give health benefits and help those workers who got injured .In 19th century trade unions were formed by skilled workers.

Knights of labor was a trade union formed in 1869.It attracted large number of workers and hoped to improve their working conditions.In 1880 skilled labor left Knight of labor and joined American federation of labor.It provides better working conditions.It had 500000 members by 1900.

Despite the efforts unions made less progress in this Era .

8 0

3 years ago

In what accounts should the following items be classified? (a) Coins and currency. (b) U.S. Treasury (government) bonds. (c) Cer

Dimas [21]

Answer:

Explanation:

Cash: generally classify cash as a cuffent asset Cash conststs of coins, currency, and available on deposit at the bank Cash the most liquid of as*ts, is standard medium of exchange and fre basis for meas_wtng and accountmg for all other items

Cash quivalents: cash equivalents are short-term, highly liquid investments that are both readily convertible to known amount of cash.

Accounts Receivable: Receivables are clams held against customers and others for money, goods, or services

Short term investments: Investments for one year or less called as short-tem investments

Long-term assets: Long-term means more than one accounting cycle period

Items Accounts

a) Coins and currency Cash

b) U S treasury (government) bonds Cash equivalent

c) Certificate of deposit (matures in 5 months) Short term investment

d) Cash in a bank that is in receivership Account receivable.

e1) NSF check ( Returned with bank statement)(if uncollectible) A loss if uncollectible

e2) NSF check ( Returned with bank statement)(if collectible) Accounts receivables

f1) Deposited in foreign bank (exchangeability limited )(if not expendable) Other assets, if not expendable.

f2) Deposited in foreign bank (exchangeability limited )(if expendable) Cash if expendable for goods and services in a foreign country

g1) Postdated checks (if collection expected within one year) Short term investments

g2) Postdated checks (if collection expected within beyond year) long term investments

8 0

3 years ago

You have a chance to buy an annuity that pays $2,500 at the end of each year for 3 years. You could earn 5.5% on your money in o

artcher [175]

Answer:

$6,744.83

Explanation:

We calcualte the present value of a three years annuity discounted at 5.5% considering their cashflow are 2,500

$C \times \frac{1-(1+r)^{-time} }{rate} = PV\\$

C 2,500.00

time 3

rate 0.055

$2500 \times \frac{1-(1+0.055)^{-3} }{0.055} = PV\\$

PV $6,744.8334

3 0

3 years ago

The gross pay, benefits and job expenses for two different employees are shown below. Employee A: gross pay $57,200, employee be

Lemur [1.5K]

Answer:

a. The total employment compensations for the two employees are the same

Explanation:

Employee compensation refers to payment made to employees by an organization in consideration for the services rendered.

Employee compensation can be in cash form such as salary and wages, perquisites, allowances, incentives, commission, etc.

In the given case,

<u>Compensation for Employee A</u>:

= Gross Pay + Employee benefits - Job expenses

= $57200 + 5300 - 800

= $ 61,700

Similarly,

Compensation for Employee B:

= Gross Pay + Employee benefits - Job expenses

= $56,900 + $6200 - $ 1400

= $61,700

Thus, employment compensation for both A and B are the same.

4 0

3 years ago