Problem 1-23A High-Low Method; Contribution Format Income Statement [LO1-5, LO1-6] Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold $30 per unit sold Advertising expense $180,000 per quarter Sales commissions 7% of sales Shipping expense ? Administrative salaries $90,000 per quarter Insurance expense $10,000 per quarter Depreciation expense $60,000 per quarter Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow: Quarter Units Sold Shipping Expense Year 1: First 26,000 $ 170,000 Second 28,000 $ 185,000 Third 33,000 $ 227,000 Fourth 29,000 $ 190,000 Year 2: First 27,000 $ 180,000 Second 30,000 $ 195,000 Third 40,400 $ 242,000 Fourth 37,400 $ 218,000 Milden Company’s president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above. 2. In the first quarter of Year 3, the company plans to sell 35,000 units at a selling price of $60 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)
In: Accounting
Titans, Inc uses a periodic inventory system. One of the store's most popular products is a nerf-type basketball. The inventory quantities, purchases, and sales of this product for the most recent year are as follows:
| Number of Units | Cost per Unit | Total Cost | ||
| Inventory, January | 300 | $5.20 | $1,560 | |
| Purchase, March 12 | 100 | $5.60 | $560 | |
| Purchase, June 19 | 350 | $6.50 | $2,275 | |
| Purchase, September 3 | 250 | $8.10 | $2,025 | |
| Units Sold | 800 |
A. What is the cost of the December 31 inventory and the cost of goods sold for the basketballs during the year under each of the following cost flow assumptions? Show your work.
1. First in, first-out
2. Last in, first-out
3. Weighted Average cost (round to the nearest dollar, except unit cost)
B. Which of the three inventory pricing methods provides the most useful balance sheet valuation of inventory considering the current replacement cost of the basketballs? Explain.
C. Which of the three inventory pricing methods provides the most useful measure of income in light of the costs incurred by Titans to replace the basketballs when they are sold? Consider which method results in a net income measure that is most predictive of future profitability. In other words, if you were thinking about buying stock in Titans, which inventory pricing measure gives you the most useful measure of its future profitability? Explain.
In: Accounting
Exercise 8-3 Direct Materials Budget [LO8-4]
Four grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk oil is $2.10 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3:
| Year 2 | Year 3 | ||||||
| First | Second | Third | Fourth | First | |||
| Budgeted production, in bottles | 98,000 | 128,000 | 188,000 | 138,000 | 108,000 | ||
Musk oil has become so popular as a perfume ingredient that it has become necessary to carry large inventories as a precaution against stock-outs. For this reason, the inventory of musk oil at the end of a quarter must be equal to 20% of the following quarter’s production needs. Some 78,400 grams of musk oil will be on hand to start the first quarter of Year 2.
Required:
Prepare a direct materials budget for musk oil, by quarter and in total, for Year 2.
| Mink Caress | |||||
| Direct Materials Budget - Year 2 | |||||
| Quarter | |||||
| First | Second | Third | Fourth | Year | |
| Required production in units of finished |
98,000 answer correct |
128,000 selected answer correct |
188,000 selected answer correct |
138,000 selected answer correct |
108,000 selected answer incorrect |
| Units of raw materials needed per unit of finished goods |
3 selected answer incorrect |
3 selected answer incorrect |
3 selected answer incorrect |
3 selected answer incorrect |
3 selected answer incorrect |
| Units of raw materials needed to meet production | 294,000 | 384,000 | 564,000 | 414,000 | 324,000 |
|
Less: Desired units of ending raw materials inventory selected answer incorrect |
76,800 selected answer incorrect |
112,800 selected answer incorrect |
82,800 selected answer incorrect |
64,800 selected answer incorrect |
64,800 selected answer incorrect |
| Total units of raw materials needed |
370,800 selected answer incorrect |
496,800 selected answer incorrect |
646,800 selected answer incorrect |
478,800 selected answer incorrect |
1,720,800 selected answer incorrect |
|
Add: Units of beginning raw materials inventory selected answer incorrect |
(78,400) selected answer correct |
(102,400) selected answer correct |
(150,400) selected answer correct |
(110,400) selected answer correct |
(441,600) selected answer incorrect |
| Units of raw materials to be purchased |
292,400 selected answer incorrect |
394,400 selected answer incorrect |
496,400 selected answer incorrect |
368,400 selected answer incorrect |
1,279,200 selected answer incorrect |
| Unit cost of raw materials |
$2.10 selected answer correct |
$2.10 selected answer correct |
$2.10 selected answer correct |
$2.10 selected answer correct |
$2.10 selected answer correct |
| Cost of raw materials to purchased | $614,040 | $828,240 | $1,042,440 | $773,640 | $2,686,320 |
In: Accounting
Calculating the Cost of Equity Gabriel Industries stock has a beta of 1.12. The company just paid a dividend of $1.15, and the dividends are expected to grow at 4 percent. The expected return on the market is 11.4 percent, and Treasury bills are yielding 3.8 percent. The most recent stock price is $85.
a. Calculate the cost of equity using the dividend growth model method.
b. Calculate the cost of equity using the SML method.
c. Why do you think your estimates in (a) and (b) are so different?
In: Finance
Which of the following is true of sole proprietorships in the United States?
| There are no opportunity costs involved in operating such firms. |
| They offer the owners less personal liability than the other forms of business organization. |
| Such firms employ only one individual. |
| They are responsible for a large portion of the total production of goods and services in the U.S. economy. |
| They are the most important form of business organization in terms of their numbers. |
Taxes collected on the basis of the benefits-received principle:
| tend to redistribute income from rich to poor. |
| make it possible for the government to spend money on activities that markets cannot provide. |
| do not vary in amount among the taxpayers. |
| connect the revenue side of the budget with the spending side of the budget. |
| provide states with their main sources of revenue. |
Which of the following is true of sole proprietorships in the United States?
| There are no opportunity costs involved in operating such firms. |
| They offer the owners less personal liability than the other forms of business organization. |
| Such firms employ only one individual. |
| They are responsible for a large portion of the total production of goods and services in the U.S. economy. |
| They are the most important form of business organization in terms of their numbers. |
Which of the following is true of a recession?
| It is typically accompanied by inflation and investment growth. |
| It begins after an expansion has peaked. |
| It is typically longer than periods of expansion. |
| It continues as long as actual output exceeds the potential output. |
| It lasts for more than two years on an average. |
In: Economics
4. Now assume that your wealthy grandfather wants to invest some
money in your behalf. He wants the money to be worth $65,000 on
December 31, 2025. How much money will he need to invest on a
one-time basis on December 31, 2020 in order to earn enough
interest to accumulate to $65,000 by December 31, 2025? Assume a 5%
interest rate. (Hint: I recommend that you use the PV formula in
Excel to solve this problem.)
Use the information from Question 4 except assume that the interest
rate is 3% per year. How much will he have to invest on a one-time
basis on December 31, 2020 to have $65,000 by December 31, 2025?
Please use excel and show the formula and screenshot
In: Accounting
Jeffrey Vaughn, president of Frame-It Company, was just concluding a budget meeting with his senior staff. It was November of 20x0, and the group was discussing preparation of the firm’s master budget for 20x1. “I’ve decided to go ahead and purchase the industrial robot we’ve been talking about. We’ll make the acquisition on January 2 of next year, and I expect it will take most of the year to train the personnel and reorganize the production process to take full advantage of the new equipment.”In response to a question about financing the acquisition, Vaughn replied as follows: “The robot will cost $1,000,000. We’ll finance it with a one-year $1,000,000 loan from Shark Bank and Trust Com-pany. I’ve negotiated a repayment schedule of four equal installments on the last day of each quarter. The interest rate will be 10 percent, and interest payments will be quarterly as well.” With that the meeting broke up, and the budget process was on.Frame-It Company is a manufacturer of metal picture frames. The firm’s two product lines are designated as S (small frames, 5×7 inches) and L (large frames, 8×10 inches). The primary raw materials are flexible metal strips and 9-inch by 24-inch glass sheets. Each S frame requires a 2-foot metal strip; an L frame requires a 3-foot strip. Allowing for normal breakage and scrap glass, Frame-It can get either four S frames or two L frames out of a glass sheet. Other raw materials, such as cardboard backing, are insignificant in cost and are treated as indirect materials. Emily Jackson, Frame-It’s controller, is in charge of preparing the master budget for 20x1. She has gathered the following information:
1. Sales in the fourth quarter of 20x0 are expected to be 50,000 S frames and 40,000 L frames. The sales manager predicts that over the next two years, sales in each product line will grow by 5,000 units each quarter over the previous quarter. For example, S frame sales in the first quarter of 20x1 are expected to be 55,000 units.
2. Frame-It’s sales history indicates that 60 percent of all sales are on credit, with the remainder of the sales in cash. The company’s collection experience shows that 80 percent of the credit sales are collected dur-ing the quarter in which the sale is made, while the remaining 20 percent is collected in the following quarter. (For simplicity, assume the company is able to collect 100 percent of its accounts receivable.)
3. The S frame sells for $10, and the L frame sells for $15. These prices are expected to hold con-stant throughout 20x1.
4. Frame-It’s production manager attempts to end each quarter with enough finished-goods inven-tory in each product line to cover 20 percent of the following quarter’s sales. Moreover, an attempt is made to end each quarter with 20 percent of the glass sheets needed for the following quarter’s production. Since metal strips are purchased locally, Frame-It buys them on a just-in-time basis; inventory is negligible.
5. All of Frame-It’s direct-material purchases are made on account, and 80 percent of each quarter’s purchases are paid in cash during the same quarter as the purchase. The other 20 percent is paid in the next quarter.
6. Indirect materials are purchased as needed and paid for in cash. Work-in-process inventory is negligible.
7. Projected production costs in 20x1 are as follows:
S Frame L Frame
Direct material:
Metal strips: S: 2 ft. @ $1 per foot .............................$2
L: 3 ft. @ $1 per foot ......................................................$3
Glass sheets: S: ¼ sheet @ $8 per sheet .................2
L: ½ sheet @ $8 per sheet .............................................4
Direct labor:
.1 hour @ $20 per hour ..............................................2 2
Production overhead:
.1 direct-labor hour × $10 per hour ........................... 1 1
Total production cost per unit ...................................$7 $10
8. The predetermined overhead rate is $10 per direct-labor hour. The following production overhead costs are budgeted for 20x1.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Entire Year
Indirect material ................................. $10,200 $11,200 $12,200 $13,200 $46,800
Indirect labor ...................................... 40,800 44,800 48,800 52,800 187,200
Other overhead .................................. 31,000 36,000 41,000 46,000 154,000
Depreciation ....................................... 20,000 20,000 20,000 20,000 80,000
Total overhead .................................... $102,000 $112,000 $122,000 $132,000 $468,000
All of these costs will be paid in cash during the quarter incurred except for the depreciation charges.
9. Frame-It’s quarterly selling and administrative expenses are $100,000, paid in cash.
0. Jackson anticipates that dividends of $50,000 will be declared and paid in cash each quarter.
11. Frame-It’s projected balance sheet as of December 31, 20x0, follows:
Cash ................................................................................................................................................................$95,000
Accounts receivable .......................................................................................................................................132,000
Inventory:
Raw material ..............................................................................................................................................59,200
Finished goods ..........................................................................................................................................167,000
Plant and equipment (net of accumulated depreciation) .............................................................................8,000,000
Total assets ...............................................................................................................................................$8,453,200
Accounts payable ...........................................................................................................................................$99,400
Common stock ...............................................................................................................................................5,000,000
Retained earnings ..........................................................................................................................................3,353,800
Total liabilities and stockholders’ equity .......................................................................................................$8,453,200
7. Prepare a budgeted schedule of cost of goods manufactured and sold for the year 20x1. (Hint: In the budget, actual and applied overhead will be equal.)
8. Prepare Frame-It’s budgeted income statement for 20x1. (Ignore income taxes.)
9. Prepare Frame-It’s budgeted statement of retained earnings for 20x1.
10. Prepare Frame-It’s budgeted balance sheet as of December 31, 20x1.
Budgets required:
sales budget
cash receipts budget
production budget
direct-material budget
cash disbursement budget
summary cash budget
budgeted schedule of costs of good manufactured and sold fot yeat 20x1
budgeted income statement 20x1
budgeted statement of retained earnings 20x1
budgeted balance sheet as of decemeber 20x1
In: Accounting
Jones Corporation has the following budgeted sales for the selected four-month period:
|
Month |
Unit Sales |
|
July |
35,000 |
|
August |
20,000 |
|
September |
30,000 |
|
October |
25,000 |
|
Sales price per unit is $200 |
|||||||||||
|
Plans are to have an inventory of finished product equal to 30% of the unit sales for the next month. There was 10,500 units in beginning inventory on July 1st. |
|||||||||||
|
Five pounds of materials are required for each unit produced. Each pound of material costs $10. Inventory levels for materials equal 20% of the production needs for the next month. |
|||||||||||
|
Desired ending inventory for September is 30,500 pounds of material. Beginning inventory for July was 25,000 pounds of material. |
|||||||||||
|
Each unit requires 2 hours of direct labor and the average wage rate is $20 per hour. |
|||||||||||
|
Variable overhead rate is $5 per direct labor hour. There is also fixed overhead of $40,000 per month. |
|||||||||||
|
The company pays a 2% commission on sales. |
|||||||||||
|
Company has fixed selling and administrative expenses as follows: Rent $10,000/month Utilities $2,000/month Advertising $500/month Office Salaries $25,500/month
|
In: Accounting
Giant Film Company just paid a quarterly dividend of $3 per share yesterday, and has a required return of 12 percent per year. Please answer the following questions:
a. If Giant Film’s future dividends are expected to stay at $3 per quarter forever, what should Giant Film’s current stock price be?
b. If Giant Film’s future dividends are expected to grow at 2% per quarter from now on, and its EPS will stay at $6 per quarter in the foreseeable future, what’s Giant Film’s current stock price?
c. If Giant Film’s future dividends are expected to grow at 10% in the first quarter, 20% in the second quarter, and then turn into a 2% per quarter constant growth rate. What’s Giant Film’s current stock price?
In: Finance
I. You have studied the chapters on unemployment and business cycles. Please review those chapters before you answer this question
a) Find the time series data (quarterly or monthly) on the unemployment rate, inflation rate and real GDP growth in the U.S. from 1980 to 2005, and discuss whether the Okun’s Law is valid or not. Then, discuss whether the Phillips curve exists in the U.S. economy( you have to report your data source and or the website).
b) Which recession is most severe in terms of its depth and the duration of unemployment?
c) Why unemployment rises when the economic is recovering? what kinds of unemployment is it ?
II. Monetary policy will have different impact on the equilibrium rate of interest and GDP. Try to draw three different IS curves with different slopes and show
a) The different impact of the same easy money policy on interest rate and GDP in these different IS curves
b) Monetary policy is most effective under what conditions ( which IS curve). Why ?
c) What determine the slopes of IS curve. Review chapter 14 on sticky price and flexible price model to answer the percentage distribution of both types of firms ,i.e. s vs ( 1-s) under different IS curves( hint : refer to the equations on. P. 408 and p. 411 that
P=EP+{( 1-s)/a/s} ( ( Y-Y bar) p. 408 Y= Y bar + alpha ( P-EP). P. 411
| Year | Growth | Unemployment | Inflation | Business Cycle |
|---|---|---|---|---|
| 1929 | NA | 3.2% | 0.6% | Aug peak and Oct. market crash |
| 1930 | -8.5% | 8.7% | -6.4% | Contraction |
| 1931 | -6.4% | 15.9% | -9.3% | Contraction |
| 1932 | -12.9% | 23.6% | -10.3% | Contraction |
| 1933 | -1.2% | 24.9% | 0.8% | New Deal and March trough |
| 1934 | 10.8% | 21.7% | 1.5% | Expansion |
| 1935 | 8.9% | 20.1% | 3% | Expansion |
| 1936 | 12.9% | 16.9% | 1.4% | Expansion |
| 1937 | 5.1% | 14.3% | 2.9% | May peak |
| 1938 | -3.3% | 19% | -2.8% | June trough |
| 1939 | 8% | 17.2% | 0% | Expansion and Dust Bowl ended |
| 1940 | 8.8% | 14.6% | 0.7% | |
| 1941 | 17.7% | 9.9% | 9.9% | Expansion and WWII |
| 1942 | 18.9% | 4.7% | 9% | Expansion |
| 1943 | 17% | 1.9% | 3% | Expansion |
| 1944 | 8% | 1.2% | 2.3% | Bretton-Woods |
| 1945 | -1% | 1.9% | 2.2% | Feb. peak, recession, Oct. trough |
| 1946 | -11.6% | 3.9% | 18.1% | Expansion and Fed cuts |
| 1947 | -1.1% | 3.9% | 8.8% | Marshall Plan and Cold War |
| 1948 | 4.1% | 4% | 3% | Nov. peak |
| 1949 | -0.6% | 6.6% | -2.1% | Oct. trough and NATO |
| 1950 | 8.7% | 4.3% | 5.9% | Expansion and Korean War |
| 1951 | 8% | 3.1% | 6% | Expansion |
| 1952 | 4.1% | 2.7% | 0.8% | Expansion |
| 1953 | 4.7% | 4.5% | 0.7% | War ended and July peak |
| 1954 | -0.6% | 5% | -0.7% | May trough, Dow at 1929 level |
| 1955 | 7.1% | 4.2% | 0.4% | Expansion |
| 1956 | 2.1% | 4.2% | 3% | Expansion |
| 1957 | 2.1% | 5.2% | 2.9% | Aug peak |
| 1958 | -0.7% | 6.2% | 1.8% | April trough |
| 1959 | 6.9% | 5.3% | 1.7% | Fed raised rates |
| 1960 | 2.6% | 6.6% | 1.4% | April peak and Fed cut |
| 1961 | 2.6% | 6% | 0.7% | JFK spending and Feb. trough |
| 1962 | 6.1% | 5.5% | 1.3% | Cuban Missile Crisis |
| 1963 | 4.4% | 5.5% | 1.6% | LBJ spending, Fed raised rate |
| 1964 | 5.8% | 5% | 1% | Fed raised rate |
| 1965 | 6.5% | 4% | 1.9% | Vietnam War, Fed raised rate |
| 1966 | 6.6% | 3.8% | 3.5% | Expansion, Fed raised rate |
| 1967 | 2.7% | 3.8% | 3% | Expansion |
| 1968 | 4.9% | 3.4% | 4.7% | Fed raised rate |
| 1969 | 3.1% | 3.5% | 6.2% | Nixon, Fed raised rate, Dec. peak |
| 1970 | 0.2% | 6.1% | 5.6% | Nov. trough, Fed cut rate |
| 1971 | 3.3% | 6% | 3.3% | Expansion and Wage-price controls |
| 1972 | 5.3% | 5.2% | 3.4% | Expansion |
| 1973 | 5.6% | 4.9% | 8.7% | Vietnam War and gold standard ended, Nov. peak. |
| 1974 | -0.5% | 7.2% | 12.3% | Stagflation, Watergate, Fed raised rate |
| 1975 | -0.2% | 8.2% | 6.9% | March trough, Fed cut rate |
| 1976 | 5.4% | 7.8% | 4.9% | Expansion, Fed cut rate |
| 1977 | 4.6% | 6.4% | 6.7% | Carter |
| 1978 | 5.5% | 6% | 9% | Fed raised rate |
| 1979 | 3.2% | 6% | 13.3% | Fed raised then lowered rate |
| 1980 | -0.3% | 7.2% | 12.5% | Jan. peak, Fed raised rate, July trough |
| 1981 | 2.5% | 8.5% | 8.9% | Reagan, Expansion peaked in July |
| 1982 | -1.8% | 10.8% | 3.8% | Nov. trough, Fed cut rate |
| 1983 | 4.6% | 8.3% | 3.8% | Reagan spent on defense |
| 1984 | 7.2% | 7.3% | 3.9% | Expansion |
| 1985 | 4.2% | 7% | 3.8% | Expansion |
| 1986 | 3.5% | 6.6% | 1.1% | Reagan cut taxes |
| 1987 | 3.5% | 5.7% | 4.4% | Black Monday |
| 1988 | 4.2% | 5.3% | 4.4% | Expansion, Fed raised rate |
| 1989 | 3.7% | 5.4% | 4.6% | S&L Crisis |
| 1990 | 1.9% | 6.3% | 6.1% | July peak |
| 1991 | -0.1% | 7.3% | 3.1% | March trough |
| 1992 | 3.5% | 7.4% | 2.9% | Expansion, Fed cut rate |
| 1993 | 2.8% | 6.5% | 2.7% | Expansion |
| 1994 | 4% | 5.5% | 2.7% | Expansion |
| 1995 | 2.7% | 5.6% | 2.5% | Fed raised rate |
| 1996 | 3.8% | 5.4% | 3.3% | Fed cut rate |
| 1997 | 4.4% | 4.7% | 1.7% | Fed raised rate |
| 1998 | 4.5% | 4.4% | 1.6% | LTCM crisis |
| 1999 | 4.8% | 4% | 2.7% | Expansion |
| 2000 | 4.1% | 3.9% | 3.4% | Expansion |
| 2001 | 1% | 5.7% | 1.6% | March peak, 9/11, and Nov. trough |
| 2002 | 1.7% | 6% | 2.4% | Expansion |
| 2003 | 2.9% | 5.7% | 1.9% | JGTRRA |
| 2004 | 3.8% | 5.4% | 3.3% | Expansion |
| 2005 | 3.5% | 4.9% | 3.4% | Expansion |
| 2006 | 2.7% | 4.4% | 2.5% | Expansion |
In: Economics