LO 5
(Learning Objective 5: Use the COGS model to make management decisions, and estimate amount of inventory to purchase) Eddie’s Convenience Stores’ income statement for the year ended December 31, 2017, and its balance sheet as of December 31, 2017, are as follows:
A | B | |
1 | Eddie’s Convenience Stores Income Statement Year Ended December 31, 2017 |
|
2 | Sales | $ 958,000 |
3. | Cost of sales | 717,000 |
A | Gross profit | 241,000 |
5 | Operating expenses | 108,000 |
6 | Net income | $ 133,000 |
7 |
The business is organized as a proprietorship so it pays no corporate income tax. The owner is budgeting for 2018 and expects sales and cost of goods sold to increase by 9%. To meet customer demand, ending inventory will need to be $84,000 at December 31, 2018. The owner hopes to earn a net income of $156,000 next year.
Requirements
1. One of the most important decisions a manager makes is the amount of inventory to purchase. Show how to determine the amount of inventory to purchase in 2018.
2. Prepare the store’s
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Financial Accounting (12th Edition) (What's New in Accounting)
- 7:28S W □ e6-20 Learning Objectives 2, 3 1. COGS $2,140 ⠀⠀⠀ Assume that AB Tire Store completed the following perpetual inventory transactions for a line of tires: May 1 Beginning merchandise inventory 11 Purchase 23 Sale 26 Purchase 29 Sale QAA C 16 tires @ $65 each 363/ 1480 10 tires @ $78 each 12 tires @ $88 each 14 tires @ $ 80 each Requirements 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method. 18 tires @ $ 88 each 5G 70% Ę 2. Compute cost of goods sold and gross profit using the LIFO inventory costing method. GO ||| 0 < : ×arrow_forwardI IBM Learning = Copy of Jacqueline. Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 4 units at $4,200 $16,800 Aug. 7 Purchase 15 units at $4,300 64,500 Dec. 11 Purchase 13 units at $4,400 57,200 32 units $138,500 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $ 78,700 V b. Last-in, first-out (LIFO) 77,000 V Weighted average cost C. Feedback Check My Work a. When the FIFO method is used, costs are included in cost of merchandise sold in the order in which they were purchased. b. When the LIFO method is used, the cost of the units…arrow_forwardFor all problems, assume the perpetual inventory system is used unless stated otherwise. P6-28A Accounting for inventory using the perpetual inventory system- FIFO, LIFO, and weighted-average Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on Merchandise Inventory 363 Learning Objectives 2, 3 2. Ending Merch. Inv., $990 account as follows: Jan. 5 Purchase 156 crates @ $ 64 each 13 Sale 180 crates @$ 100 each 18 Purchase 114 crates @ $ 75 each 26 Sale 150 crates @ $ 116 each Requirements 1 Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. 2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. 3. Prepare a perpetual inventory record,…arrow_forward
- Formative Assessment FA10: Required: Prepare Income Statement. Reflect in the income statement the net sales, net purchases, merchandise available for sale, cost of goods sold, gross profit, total operating expenses and net income. Below are the balances of income statement accounts of Gwaping's Store as of Dec. 31, 2017. Amounts Inventory, Dec. 31, 2017 486,945 Inventory, Jan. 01, 2017 395,870 Bad Debts Expense Depreciation Expense Freight - in 11,233 24,301 45,689 Freight Out Miscellaneous Expense Purchase Disco unts Purchase Returns 39,978 6,492 14,377 3,445 Purchases 945,788 46,800 185,972 Rent Expense Salaries Expense Sales 1,329,743 Sales Discounts 48,544 Sales Returns 52,301 Supplies Expense Utilities Expense 8,978 26,979arrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Griffin Company’s inventory records for its retail division show thefollowing at December 31:Dec 1 Beginning inventory ............... 9 units @ $165 = $1,48515 Purchase................................. 5 units @ 166 = $ 83026 Purchase................................. 13 units @ 175 = $2,275At December 31, 11 of these units are on hand. Journalize the following for Griffin Companyunder the perpetual system:1. Total December purchases in one summary entry. All purchases were on credit.2. Total December sales and cost of goods sold in two summary entries. The selling price was$500 per unit, and all sales were on credit. Assume that Griffin uses the FIFO inventorymethod.3. Under FIFO, how much gross profit would Griffin earn for the month ending December 31?What is the FIFO cost of Griffin Company’s ending inventory?arrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Spear Corporation’s inventory records for its retail division show thefollowing at May 31:May 1 Beginning inventory ............... 10 units @ $160 = $1,60015 Purchase................................. 5 units @ 161 = 80526 Purchase................................. 14 units @ 170 = 2,380At May 31, 11 of these units are on hand. Journalize the following for Spear Corporation underthe perpetual system:1. Total May purchases in one summary entry. All purchases were on credit.2. Total May sales and cost of goods sold in two summary entries. The selling price was $560per unit, and all sales were on credit. Assume that Spear uses the FIFO inventory method.3. Under FIFO, how much gross profit would Spear earn for the month ending May 31? Whatis the FIFO cost of Spear Corporation’s ending inventory?arrow_forward
- Tube C CengageNOWV2 | Online teaching and learning resourc... Using the following information for a periodic inventory system, what is the amount of net income (loss)? Purchases Inventory, September 1 Administrative expense Rent revenue Sales 1,146 Selling expense $825 Inventory, September 30 11,074 58,402 $28,452 7,276 697 Interest expense Oa. $32,565 Ob. $807 Oc. $24,654 X Od. $27,288 Dashboard 807arrow_forward16:40 chegg.com/homework-h = Chegg Expert Q&A Find solutions to your homework Question 2-36. COST OF GOODS PURCHASED, COST OF GOODS SOLD, AND INCOME STATEMENT. The following data are for Mama Retail Outlet Stores. The account balances (in thousands) are for 2020. Marketing and advertising costs Merchandise inventory, January 1, 2020 Shipping of merchandise to customers Depreciation on store fixtures Purchases General and administrative costs Merchandise inventory, December 31, 2020 Merchandise freight-in Purchase returns and allowances Purchase discounts Revenues Show transcribed data $ 54,000 94,000 10,000 8,800 ||| 70 521,000 63,000 101,000 21,000 25,000 22,000 690,000 Required 1. Compute (a) the cost of goods purchased and (b) the cost of goods sold. 2. Prepare the income statement for 2020.arrow_forwardQuestion: Assume a Watercrest Sports outlet store began October 2020 with 47 pairs of water skis that cost the store $38 each. The sale price of these water skis was $67. During October, the store completed these inventory transactions: 2. Determine the store’s cost of goods sold for October. Also compute gross profit for October. For the part, Sales [(47 units x $67)+(44 units x $68)] = $6,141 I don't understand what is in bolded, please explain where you get the numbers incuding the ones in dollars please.arrow_forward
- Bookmarks Window Help Thu De A v2.cengagenow.com scent Tech.. BLearning Module 8- ACCT1105: Financial Ac.. E CengageNOwWv2 | Onltine teaching and learnin.. Cengage Learning eBook Show Me How Inventory Analysis A company reports the following: Cost of merchandise sold $558,000 Average inventory 45,000 Determine (a) the inventory turnover and (b) the number of days' sales in inventory. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume 365 days a year. a. Inventory turnover b. Number of days' sales in inventory days Previous Next Check My Work All work saved. Save and Exit Submit Assignment for Grading tv 16 MacBook Air 888 F10 80 F9 FB F6 F4 FS F3 F2 & 23 $ 7 8 3 4 { T Y U W E K S F G M .. .. - の * 00arrow_forward- Chapter 8 Saved Help Save Selected financial statement data from Western Colorado Stores is shown below. 2021 2020 Net sales Cost of goods sold Operating expenses Inventory $975, 000 780, 000 110,000 130, 000 $995, 000 800,000 90,000 110, 000 Required: 1. Compute the gross profit ratio for 2021. (Round your "Percentage" answer to two decimal places (i.e., 0.1234 should be entered as 12.34).) 2. Compute the inventory turnover ratio for 2021. (Round your answer to two decimal places.) 1Gross profit ratie- 2 Inventory tumover ratioarrow_forward7:30 S&WYDO □ E6A-27 Computing periodic inventory amounts Learning Objective 7 Appendix 6A ::: e6a-27 Consider the data of the following companies which use the periodic inventory system: Company Net Large Small Medium Petite Sales Revenue $ 105,000 Requirements. (b) 96,000 80,000 Beginning Net Cost Merchandise of Inventory $ 23,000 $ 59,000 27,000 (d) Purchases 8,000 94,000 58,000 366/ 1480 QAA (f) Ending Merchandise of Inventory Cost Goods Sold 5G l 69% $ 22,000 $ (a) Gross Profit $ 45,000 (c) 99,000 40,000 24,000 68,000 (e) 6,500 (g) 44,000 IG b III O < ×arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education