Questions
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period...

The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 25 $1,200 $30,000
8 Purchase 75 1,240 93,000
11 Sale 40 2,000 80,000
30 Sale 30 2,000 60,000
May 8 Purchase 60 1,260 75,600
10 Sale 50 2,000 100,000
19 Sale 20 2,000 40,000
28 Purchase 80 1,260 100,800
June 5 Sale 40 2,250 90,000
16 Sale 25 2,250 56,250
21 Purchase 35 1,264 44,240
28 Sale 44 2,250 99,000

Required:

1. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Round the weighted average unit cost to the nearest cent.

Inventory, June 30 $
Cost of goods sold $

2. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system.

Inventory, June 30 $
Cost of goods sold $

3. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system.

Note: Round the weighted average unit cost to the nearest dollar and final answers to the nearest dollar.

Inventory, June 30 $
Cost of goods sold $

4. Compare the gross profit and June 30 inventories using the following column headings. Enter all amounts as positive numbers.

FIFO LIFO Weighted Average
Sales $ $ $
Cost of goods sold
Gross profit $ $ $
Inventory, June 30 $ $ $

In: Accounting

Periodic Inventory by Three Methods The beginning inventory for Dunne Co. and data on purchases and...

Periodic Inventory by Three Methods

The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 25 $1,200 $30,000
8 Purchase 75 1,240 93,000
11 Sale 40 2,000 80,000
30 Sale 30 2,000 60,000
May 8 Purchase 60 1,260 75,600
10 Sale 50 2,000 100,000
19 Sale 20 2,000 40,000
28 Purchase 80 1,260 100,800
June 5 Sale 40 2,250 90,000
16 Sale 25 2,250 56,250
21 Purchase 35 1,264 44,240
28 Sale 44 2,250 99,000

Required:

1. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Round the weighted average unit cost to the nearest cent.

Inventory, June 30 $
Cost of goods sold $

2. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system.

Inventory, June 30 $
Cost of goods sold $

3. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system.

Note: Round the weighted average unit cost to the nearest dollar and final answers to the nearest dollar.

Inventory, June 30 $
Cost of goods sold $

4. Compare the gross profit and June 30 inventories using the following column headings. Enter all amounts as positive numbers.

FIFO LIFO Weighted Average
Sales $ $ $
Cost of goods sold
Gross profit $ $ $
Inventory, June 30 $ $ $

In: Accounting

Periodic Inventory by Three Methods The beginning inventory for Dunne Co. and data on purchases and...

Periodic Inventory by Three Methods

The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 25 $1,200 $30,000
8 Purchase 75 1,240 93,000
11 Sale 40 2,000 80,000
30 Sale 30 2,000 60,000
May 8 Purchase 60 1,260 75,600
10 Sale 50 2,000 100,000
19 Sale 20 2,000 40,000
28 Purchase 80 1,260 100,800
June 5 Sale 40 2,250 90,000
16 Sale 25 2,250 56,250
21 Purchase 35 1,264 44,240
28 Sale 44 2,250 99,000

Required:

1. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Round the weighted average unit cost to the nearest cent.

Inventory, June 30 $
Cost of goods sold $

2. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system.

Inventory, June 30 $
Cost of goods sold $

3. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system.

Note: Round the weighted average unit cost to the nearest dollar and final answers to the nearest dollar.

Inventory, June 30 $
Cost of goods sold $

4. Compare the gross profit and June 30 inventories using the following column headings. Enter all amounts as positive numbers.

FIFO LIFO Weighted Average
Sales $ $ $
Cost of goods sold
Gross profit $ $ $
Inventory, June 30 $ $ $

In: Accounting

Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance Given are the daily returns...

Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance

Given are the daily returns for two stocks X and Y for five business days in last week. If you have 1000 dollars to invest and you are considering to invest 600 dollars in stock X and 400 dollars in stock Y. Calculate the following

A. average stock return for individual stocks

B. variance and standard deviations for the individual stocks

C. calculate the covariance and correlation between the two stocks

D. weights of the stocks in the portfolio

E. portfolio expected return

F. portfolio standard deviation and portfolio variance

Day

Stock X (return in %)

Stock Y (return in %)

1

10

- 3

2

6

5

3

8

7

4

1

4

5

-5

2

In: Finance

Forchen, Inc., provided the following information for two of its divisions for last year:            Small...

Forchen, Inc., provided the following information for two of its divisions for last year:

           Small Appliances
Division
Cleaning Products
Division
Sales $34,690,000      $31,350,000     
Operating income 2,365,700      1,252,700     
Operating assets, January 1 6,397,000      5,670,000     
Operating assets, December 31 7,550,000      6,590,000     

Forchen, Inc., requires an 7 percent minimum rate of return.

Required:

1. Calculate residual income for the Small Appliances Division.

$ _____

2. Calculate residual income for the Cleaning Products Division.

$ _____

3. What if the minimum required rate of return was 8 percent? How would that affect the residual income of the two divisions?

Small Appliances Division residual income would be HIGHER/LOWER/UNAFFECTED
Cleaning Products Division residual income would be HIGHER/LOWER/UNAFFECTED

In: Accounting

1. Fill in the blanks and give reasons: Company A Company B ROE 8% 8% Profit...

1. Fill in the blanks and give reasons:

Company A

Company B

ROE

8%

8%

Profit Margin %

7%

4%

TAT

1.7

3.0

ROA

11%

8.7%

Generic Strategy?

A. Fill in the generic strategy row above. (5 points)

The answer the following questions:

B. How different are the two firms’ financials? Explain each ratio. (5 points)

C. How are they related to their strategies? (5 points)

  1. A. How would you interpret a current ratio of 0.8? (2 points)

B. Is it good or bad for the firm? (2 points)

C. What information you would need to extra to interpret it? (1 points)

  1. Use this information for New Tech Company to answer the following question. You may (or may not) need to fill in missing information.

          NEW TECH COMPANY

Income Statement

2010

2011

2012

Sales

100

110

120

Cost of goods sold

50

51

52

Depreciation

20

20

20

General, sales & admin expenses

70

65

60

Taxes

10

10

10

Net Income

Balance Sheet

2010

2011

2012

Current Assets

40

45

40

Property, plant & equipment

60

55

60

Total Assets

Current Liabilities

40

40

35

Long-Term Liabilities

10

10

15

Equity

50

50

50

Total Liabilities & Equity

INDUSTRY AVERAGE RATIOS

2010

2011

2012

CR (Current Ratio)

1.5

1.5

1

DR (Debt Ratio)=TL/TA

60%

60%

60%

TAT (Total Asset Turnover)

2

2.2

2.5

PM (Profit Margin)

4%

5%

6%

Sales Growth

3%

2.50%

3%

Profit Growth

5%

25%

20%

Which of the following items characterize New Tech Company? (It may be more than one option).

EXPLAIN (and report your calculations) (15 points)

  1. High debt & unprofitable
  2. Low debt & unprofitable
  3. Decreasing profit margin
  4. High Asset Utilization Performance
  5. Low Asset Utilization Performance
  6. Increasing sales with a decreasing sales growth rate
  7. 1, 3 and 5 characterize New Tech Company

  1. Using CAPSIM Practice Round Courier Reports for the Rounds :

A. Identify your closest competitor at the end of Round 3 ( Hint: identify a company with products & pricing (5 points)

B. Identify industry revenue (growth) averages, PM growth, and CM growth for the 3rd Practice Rounds (10 points) for all the players in this industry

C. Create & growth and common-size “Selected Financial Statistics” Statements for from 2nd Round to 3rd Round (15 points)

D.

I.Write down the steps of strategic financial analysis ( 3 points)

II. Compare and contrast the performance of your firm vs. industry & the closest competitor. (12 points)

E. Which company performed the best? Which company performed the worst? for the end of the 3rd Practice Round (10 points)

In: Accounting

Using Excel Linear Solver Please answer the following, include all of the constraints. You are a...

Using Excel Linear Solver Please answer the following, include all of the constraints.

You are a project manager for a consulting firm. You are going to hire four new employees. The candidates that you are choosing from are named Amy, Bob, Charlie, Debbie, and Elizabeth. You are managing two projects that you will use your new employees to complete. Project 1 will require at least 700 labor hours and Project 2 will require at least 870 labor hours. Elizabeth is the owner’s daughter so you will have to hire her. Amy and Charlie used to work together, but they can’t stand each other. If you hire one, you can’t hire the other. You have contracts that guarantee a set fee for each of the projects. Your profit will be determined by your ability to minimize your labor costs. Each of the employees you hire will require a signing bonus. The respective signing bonuses required for each employee if hired follow: Amy $24,000; Bob $11,000; Charlie $16,000; Debbie $17,000; Elizabeth $15,000. The hourly rate you pay each employee is determined by the type of project to which they are assigned. For Project 1, the required hourly rates for each employee if hired follow: Amy $100; Bob $95; Charlie $85; Debbie $50; Elizabeth $45. For Project 2, the required hourly rates for each employee if hired follow: Amy $60; Bob $40; Charlie $75; Debbie $120; Elizabeth $130. If you hire an employee, they can be used for both projects. Labor should be allocated in one hour increments. During the lifespan of these two projects, the candidates are available to work the following number of hours: Amy 440; Bob 730; Charlie 520; Debbie 680; Elizabeth 590. Which candidates will you hire?

In: Operations Management

eBook Problem 7-31 Use a financial calculator or a program such as Excel to answer the...

eBook

Problem 7-31

Use a financial calculator or a program such as Excel to answer the questions. Round your answers to the nearest whole number.

  1. You purchase a stock for $9,000 and collect $300 at the end of each year in dividends. You sell the stock for $10,500 after five years. What was the annual return on your $9,000 investment?
      %

  2. You purchase a building for $850,000, collect annual rent (after expenses) of $110,000, and sell the building for $950,000 after seven years. What is the annual return on this investment?
      %

  3. You buy a stock for $1,000 and expect to sell it for $850 after five years but also expect to collect dividends of $130 a year. Calculate the return on this investment and prove that it is less than 13 percent.
      %

In: Finance

(PYTHON) Lottery program. The program randomly generates a two-digit number, prompts the user to enter a...

(PYTHON) Lottery program. The program randomly generates a two-digit number, prompts the user to enter a single two- digit number, and determines whether the user wins according to the following rules. Write a loop to let the user play as many times as the user wanted. Use a sentinel or flag to quit out of the loop.

1.if the user’s input matches the lottery In the exact order, the award is $10,000.

2.if all the digits in the user’s input match all the digits in the lottery number, the award is $3,000.

3. if one digit in the user’s input matches a digit in the lottery number, the award is $1,000.

In: Computer Science

Three put options on a stock have the same expiration date and strike prices of $50,...

Three put options on a stock have the same expiration date and strike prices of $50, $60, and $70. The market prices are $3, $5, and $9, respectively. Harry buys the $50 put, buys the $70 put and sells two of the $60 puts. Harry's strategy potentially makes money (i.e. positive profit) in which of the following price ranges?

$40 to $50

$70 to $80       

$85 to $95     

$55 to $65       

In: Finance