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
The article "Plugged In, but Tuned Out"† summarizes data from two surveys of kids age 8 to 18. One survey was conducted in 1999 and the other was conducted in 2009. Data on number of hours per day spent using electronic media that are consistent with summary quantities given in the article are given below (the actual sample sizes for the two surveys were much larger). For purposes of this exercise, assume that it is reasonable to regard the two samples as representative of kids age 8 to 18 in each of the 2 years that the surveys were conducted.
2009 5 9 5 8 7 6 7 9 7 9 6 9 10 9 8
1999 4 5 7 7 5 7 5 6 5 6 7 8 5 6 6
(a) Do the given data provide convincing evidence that the mean number of hours per day spent using electronic media was greater in 2009 than in 1999? Test the relevant hypotheses using a significance level of 0.01. (Use a statistical computer package to calculate the P-value. Use ?2009 ? ?1999. Round your test statistic to two decimal places, your df down to the nearest whole number, and your P-value to three decimal places.)
t =
df =
P-value =
State your conclusion.
Fail to reject H0. There is not convincing evidence that the mean number of hours per day spent using electronic media was greater in 2009 than in 1999. Reject H0. There is convincing evidence that the mean number of hours per day spent using electronic media was greater in 2009 than in 1999. Reject H0. There is not convincing evidence that the mean number of hours per day spent using electronic media was greater in 2009 than in 1999. Fail to reject H0. There is convincing evidence that the mean number of hours per day spent using electronic media was greater in 2009 than in 1999. (b) Construct and interpret a 98% confidence interval estimate of the difference between the mean number of hours per day spent using electronic media in 2009 and 1999. (Use ?2009 ? ?1999. Round your answers to two decimal places.) to hours Interpret the interval. There is a 98% chance that the true mean number of hours per day spent using electronic media in 2009 is directly in the middle of these two values. We are 98% confident that the true mean number of hours per day spent using electronic media in 2009 is between these two values. There is a 98% chance that the true difference in mean number of hours per day spent using electronic media in 2009 and 1999 is directly in the middle of these two values. We are 98% confident that the true mean number of hours per day spent using electronic media in 1999 is between these two values. We are 98% confident that the true difference in mean number of hours per day spent using electronic media in 2009 and 1999 is between these two values.
In: Statistics and Probability
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
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
| 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
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
(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