Accounting for Changing Inventory Costs
In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking each product line had exceeded the profits earned. In December, a supplier asked her to sell a prepackaged spa kit. Feeling she could manage a single product line, Nicole agreed. Nicole’s Getaway Spa (NGS) would make monthly purchases from the supplier at a cost that included production costs and a transportation charge. NGS would keep track of its new inventory using a perpetual inventory system.
On December 31, NGS purchased 10 units at a total cost of $6 per unit. Nicole purchased 25 more units at $8 in February, in March, Nicole purchased 15 units at $10 per unit. In May, 50 units were purchased at $9.80 per unit. In June, NGS sold 50 units at a selling price of $12 per unit and 35 units at $10 per unit.
Required:
- 1. Explain whether the transportation cost included in each purchase should be recorded as a cost of the inventory or immediately expensed.
- 2. Compute the Cost of Goods Available for Sale, Cost of Goods Sold, and Cost of Ending Inventory using the first-in, first-out (FIFO) method.
- 3. Calculate the inventory turnover ratio (round to one decimal place), using the inventory purchased on December 31 as the beginning inventory. The supplier reported that the typical inventory turnover ratio was 6.0. How does NGS’s ratio compare?
- 4. Would a different inventory cost flow assumption allow Nicole’s Getaway Spa to better minimize its income tax?
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
Fundamentals Of Financial Accounting
- Edmund Supplies Company sold 3,170 metal connectors on account to Door Incorporated for $200 each on September 15. Each metal connector costs Edmund $150 to make. Door has 60 days to return the unused goods. Edmund believes that Door will ultimately return 75 of the connectors. On September 29, Door returns 50 connectors. Edmund has a September 30 fiscal year end. At year end, Edmund believes 75 connectors is a good estimate of the total that will be returned. The cost of recovering these products is immaterial. Edmund expects to be able to resell these goods for a profit. Instructions Prepare the following journal entries on the books of Edmund Company: Entries to record the initial sales on September 15. Entries to record the return of goods September 29. Entries to record the year-end adjustment based on estimated returns on September 30.arrow_forwardDo not use EXCEL to type answers please write out answers and give explanations.arrow_forwardWesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $50. Wesley expects the following unit sales: 2, 000 2, 500 3, 100 2, 900 January February March April May 2, 200 Wesley's ending finished goods inventory policy is 20 percent of the next month's sales. Each handisaw takes approximately 0.30 hours to manufacture, and Wesley pays an average labor wage of $15.00 per hour. Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $5.00 each. The company has an ending raw materials inventory policy of 10 percent of the following month's production requirements. Materials other than the housing unit total $4.00 per handisaw. Manufacturing overhead for this product includes $60,000 annual fixed overhead (based on production of 24,000 units) and $.80 per unit variable manufacturing overhead. Wesley's selling expenses are 5 percent of sales dollars, and…arrow_forward
- Living Corner sells home wares and various otherreading-related products. One of the store's most popular products is the fluffy pillow. The pillow each sell for $26.00. Originally the pillows were handmade by a local artisan. The store's owner has been impressed with the demand for the pillow and has recently begun a small manufacturing company to produce and distribute the pillow to other stores. Estimated sales for the fourth quarter (in units) are as follows: October 9 500 November 10 200 December 12 600 Total 32 300 Required: a) Prepare a sales budget for the fourth quarter based on the above information. b) Prepare a production budget for the pillow manufacturing company. The company did not have any inventory at the end of September, but they want to maintain a 20 percent inventory at the end of each month based on the next month's sales. January's sales are expected to be low, given the post-holiday trends and are estimated to be 6800 units. c) Explain the benefits of budgeting…arrow_forwardFiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts manager is currently revising the inventory policy for XL-20, one of the chemicals used in the production process. The chemical is purchased in 10-pound canisters for $95 each. The firm uses 4,800 canisters per year. The controller estimates that it costs $150 to place and receive a typical order of XL-20. The annual cost of storing XL-20 is $4 per canister. Required: 1. Prepare a table showing the total annual cost of ordering and storing XL-20 for each of the follow- ing order quantities: 400, 600, and 800 canisters. 2. What are the weaknesses in the tabular approach?arrow_forwardPlease don't give image formatarrow_forward
- Determine the company's total cost of goods completed and COGS in December. Total cost of goods completed and COGS 69 eTextbook and Media Save for Later Attempts: 0 of 2 used Submit Answer (d1) How much gross margin did the company earn in December? (Round percentage answer to 2 decimal places, e.g. 52.75%.) Gross margin Gross margin percentage $ % If Betty had a goal of earning a 35% gross margin, did she reach her goal? .she eTextbook and Media Save for Later ✓ reach her goal, because % is than her goal of 35%. Attempts: 0 of 2 used Submit Answerarrow_forwardI'm having issues with the problem attached. Thank youarrow_forwardWesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $46. Wesley expects the following unit sales: January 3,800 February 4,000 March 4,500 April 4,300 May 3,700 Wesley’s ending finished goods inventory policy is 25 percent of the next month’s sales.Suppose each handisaw takes approximately 0.60 hours to manufacture, and Wesley pays an average labor wage of $22 per hour.Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $5.00 each. The company has an ending direct materials inventory policy of 20 percent of the following month’s production requirements. Materials other than the housing unit total $4.50 per handisaw.Manufacturing overhead for this product includes $72,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley’s selling expenses are 7…arrow_forward
- g) What is the selling price per mask if Personal Protective Gears manufactured 1,850 masks for the period under review and uses a mark-up of 25% on cost? h) How does the format of the income statement for a manufacturing concern differ from the income statement of a merchandising entity?arrow_forwardWesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $42. Wesley expects the following unit sales: January February March April May 3,400 3,600 4,100 3,900 3,300 Wesley's ending finished goods inventory policy is 20 percent of the next month's sales. Suppose each handisaw takes approximately 0.75 hour to manufacture, and Wesley pays an average labor wage of $18 per hour. Each handisaw requires two plastic components that Wesley purchases from a supplier at a cost of $3.50 each. The company has an ending direct materials Inventory policy of 25 percent of the following month's production requirements. Materials other than the plastic components total $4.50 per handisaw. Manufacturing overhead for this product includes $75,000 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley's selling expenses are 7 percent of sales…arrow_forwardHeather’s Holiday Styles has been busy in the month of November! It seems Heather’s marketing efforts have paid off, as she has answered many calls to help decorate homes for the upcoming holidays. The company carries an inventory of decorative items in its store and then installs them in creative and fun ways. The MOH costs are fairly low, since the company has just a small space to hold the inventory. The applied MOH rate is $10 per direct labor hour. As of November 30, the company carries the following balances in its inventory accounts. DM Inventory $5,500 WIP Inventory 7,250 FG Inventory 0 During December, the following events occurred. Purchased direct materials costing $14,000 on account. Used $18,600 of direct materials for jobs. Paid direct labor wages for 120 hours of labor ($25/hr). Applied MOH cost to jobs. Actually incurred $1,400 in MOH costs. Completed all jobs by the end of the month. Billed clients $40,000 for jobs completed. Closed under- or overapplied MOH using the…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning