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
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
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 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 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 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)
B. Is it good or bad for the firm? (2 points)
C. What information you would need to extra to interpret it? (1 points)
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)
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 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 questions. Round your answers to the nearest whole number.
|
In: Finance
(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, $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