Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $40,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March The following information is available: • The company budgeted sales at 12,000 units per month in February, April, and May and at 9,000 units in March. The selling price is $60 per unit. • The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. • The Inventory of finished goods on February 1 was 2,400 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the following month. There is no work in process. • The inventory of raw materials on February 1 was 2,280 pounds. At the end of each month, the raw materials inventory equals no less than 20 percent of production requirements for the following month. The company purchases materials in quantities of 250 pounds per shipment. . Selling expenses are 6 percent of gross sales. Administrative expenses, which include depreciation of $750 per month on office furniture and fixtures, total $68,400 per month. The manufacturing budget for the utensil, based on normal production of 10,000 units per month, follows. Materials (1/2 pound per utensil, 5,000 pounds, $30 per pound) Labor Variable overhead Fixed overhead (includes depreciation of $20,000) Total $ 150,000 120,000 60,000 120,000 $ 450,000 Required: a-1. Prepare schedules computing inventory budgets by months for production in units for February, March, and April. a-2. Prepare schedules computing inventory budgets by months for raw materials purchases in pounds for February and March b. Prepare a projected income statement for March. Cost of goods sold should equal the variable manufacturing cost per unit times the number of units sold plus the total fixed manufacturing cost budgeted for the period. Assume that 40 percent of sales are cash Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $40,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March The following information is available: • The company budgeted sales at 12,000 units per month in February, April, and May and at 9,000 units in March. The selling price is $60 per unit. • The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. • The Inventory of finished goods on February 1 was 2,400 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the following month. There is no work in process. • The inventory of raw materials on February 1 was 2,280 pounds. At the end of each month, the raw materials inventory equals no less than 20 percent of production requirements for the following month. The company purchases materials in quantities of 250 pounds per shipment. . Selling expenses are 6 percent of gross sales. Administrative expenses, which include depreciation of $750 per month on office furniture and fixtures, total $68,400 per month. The manufacturing budget for the utensil, based on normal production of 10,000 units per month, follows. Materials (1/2 pound per utensil, 5,000 pounds, $30 per pound) Labor Variable overhead Fixed overhead (includes depreciation of $20,000) Total $ 150,000 120,000 60,000 120,000 $ 450,000 Required: a-1. Prepare schedules computing inventory budgets by months for production in units for February, March, and April. a-2. Prepare schedules computing inventory budgets by months for raw materials purchases in pounds for February and March b. Prepare a projected income statement for March. Cost of goods sold should equal the variable manufacturing cost per unit times the number of units sold plus the total fixed manufacturing cost budgeted for the period. Assume that 40 percent of sales are cash
Expert Answer:
Answer rating: 100% (QA)
a1 Lane Products Production Schedule Budget Units For February March and April February March April ... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these mathematics questions
-
At the end of Year 5 the following information is available for Billings and Phoenix companies: Required a. Prepare common size income statements for each company. b. One company is a high-end...
-
Following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31, 2010. a. After all posting is complete on July 31, the...
-
A bus company believes that it will need the following numbers of bus drivers during each of the next five years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year...
-
Suri recently took a job in the marketing department for All Access Cable Company. After just a few days on the job. After just a few days on the job, Suri learned that the company has many layers of...
-
Don Richardson, JEM Corporations vice president of marketing is part of a management team that for several months has been discussing plans to develop a new line of business. Rumors about the major...
-
An interest rate is given as 5 percent per year nominal. Determine the effective annual rate if a. compounding is annual. b. compounding is daily. c. compounding is continuous.
-
Repeat the calculations of Example 9.5, but for a total solution normality of 0.5. Data From Example 9.5:- For the Cu 2+ /Na + exchange with a strong-acid resin, show how the fraction CuR2 in the...
-
Wabash Company specializes in refurbishing exterior painted surfaces that have been hard hit by humidity and insect debris. It uses a special technique, called pressure cleaning, before priming and...
-
Market Dynamics (10 Points) Between 1980 and 1990, the number of employed women grew sharply but the number of women employed as secretaries actually fell. There are two theories as to why this...
-
FeVer Beverages is a typical coffee shop that operates at Batangas. Recently, the general manager is facing a challenge about not meeting their target lead time of serving the hot coffee of 15...
-
Your company's summarized financial information for the beginning and projected end of the current year is as follows: Beginning of the Year End of the Year (projected) Assets $90,000 $100,000...
-
Define the EBIT-EPS indifference point.
-
Within the financial markets, explain what we mean by private placements and name the advantages and disadvantages.
-
In early 2016, Alfa Corporation issued new common stock at a market price of $30. Dividends last year were $2.00 and are expected to grow at an annual rate of 3 percent forever. Floatation costs will...
-
What is a scenario analysis? What is a sensitivity analysis? When would you perform a sensitivity analysis?
-
Name the benefits derived from the existence of stock exchanges.
-
Cash flows for an investment is given as follows: 0 1 2 3 4 5 6 CF -$150.00 $25.00 $25.00 $60.00 -$30.00 $60.00 $25.00 There is one internal rate of return (IRR) for this investment, which is 6.49%....
-
The senior management at Davis Watercraft would like to determine if it is possible to improve firm profitability by changing their existing product mix. Currently, the product mix is determined by...
-
Assume that Painless Dental Clinics, Inc., offers three basic dental services. Here are its prices and costs: Variable costs include the labor costs of the dental hygienists and dentists. Fixed costs...
-
Surveying the accounts payable records, a clerk in the controllers office noted that expenses appeared to rise significantly within one month of the close of the budget period. The organization did...
-
Assume that General Dynamics, which manufactures high-technology instruments for spacecraft, is considering the sale of a navigational unit to a government agency in India that wishes to launch its...
-
Based on Exhibit 1, the fi nancial leverage ratio for Company B is closest to: A . 0.55. B . 1.22. C . 2.22. EXHIBIT 1 Common-Size Balance Sheets for Company A, Company B, and Sector Average Company...
-
Based on Exhibit 1, which ratio indicates lower liquidity risk for Company A compared with Company B? A . Cash ratio. B . Quick ratio. C . Current ratio. EXHIBIT 1 Common-Size Balance Sheets for...
-
Under which section of a manufacturing companys cash fl ow statement are the following activities reported? Item 1: Purchases of securities held for trading Item 2: Sales of securities considered...
Study smarter with the SolutionInn App