Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 16, Problem 2R
To determine
Prepare the schedule of cost of goods manufactured and soldusing the necessary formulae.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
PLEASE INCLUDE THE EXCEL FORMULAS!! Thanks!!
Please don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first.
If someone can help I will give a thumbs up. Thanks for the help! :)
You are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file.
In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price.
Customer ID:
68YJW
Prices:
Regular
$26.95
Customer Name
Reggie Greene
Preferred
$21.95
Preferred? Y/N:
Yes
Customer Price
You are given the information below and you are requested to answer the following questions (keep your calculations at a side paper because you might need them to answer other questions also):
Beginning finished goods, 1/1/2019
$ 90,000
Ending finished goods, 31/12/2019
$ 77,000
Cost of goods sold
$ 270,000
Sales revenue
$ 500,000
Operating expenses
$ 155,000
Question: What is gross margin for 2019?
Chapter 16 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.arrow_forwardYou want to add a new Product and Services entry to your client's QuickBooks Online company. The service is installation of a server that doesn't include the cost of the hardware. Here are some steps for getting the job done. 1. Select the Gear icon, select Products and Services, then select New2. _____________________________________________3. In the Name field, type Server installation4. In the Sales information field, type Server installation5. Sale price/rate is $12506. In the Income Account drop-down, select Service/Fee Income7. Select Save and close Which option correctly completes Step 2? A. Select Product B. Select Inventory C. Select Service D. Select Non-inventory E. Select Bundlearrow_forwardA small company manufactures a certain item and sells it online. The company has a business model where the cost, C in dollars, to make x items is given by the equation C = 20/3 x + 50. The revenue R , in dollars , made by selling x items is given by the equation R = 10x. How many items must the company sell in order for the cost to equal their revenue?arrow_forward
- Tenace Corporation uses a periodicinventory system and has provided the following information about one of their laptop computers: Date Transaction Number of Units Cost per Unit 1/1 Beginning inventory 100 $800 5/5 Purchase 200 $900 8/10 Purchase 300 $1,000 10/15 Purchase 200 $1,050 During the year, 275 laptop computers were sold on 5/8 and 475 laptops were sold on 10/20. What was cost of goods sold using the LIFOcost flow assumption? Group of answer choices A)$717,500 b)$730,000 C)$703,125 D)$725,500 E)None of the abovearrow_forwardFor the Restaurant Sales database,:(a) Obtain the Min and Max amount in sales(b) For each Bin shown in the excel sheet, calculate the frequency for each bin as follows:For ex: if the Bin value is $200, the frequency is the number of entries, whose sales are Less than or equal to 200.Next Bin value is $250 => Frequency is the number of entries, whose sales is >200 and less than or equal to 250.And so on…. (c) Now that your values for Frequency and Bins is complete, use any data visualization tool/chart to plot – Sales on the X axis and Frequency on Y axis.(d) Looking at the plot /graph/chart in (c), what do you infer about the relationship?arrow_forwardSuppose you are the purchasing manager for a company that manufactures scanners and other computer peripherals. Your vendor for scanner motors is now offering "quantity discounts" in the form of instant rebates and lower shipping charges as follows. Quantity Net Price Rebate Shipping 1–500 motors $16 none $1.50 501–1,000 motors 16 $1.30 1.10 1,001–2,000 motors 16 1.90 0.80 (a) Calculate the cost of the motors, including shipping charges, for each category (in $). 1–500 motors$ 501–1,000 motors$ 1,001–2,000 motors$ (b) If you usually purchase 400 motors per month, what percent would be saved per motor by ordering 800 every two months? Round to the nearest tenth of a percent. % (c) What percent would be saved per motor by ordering 1,200 every three months? Round to the nearest tenth of a percent. % (d) How much money (in $) can be saved in a year by purchasing the motors every three months instead of every month? $ (e) What other factors besides price…arrow_forward
- The computer in May’s office is down, and May has been asked to immediately provide an equation to estimate the future purchase cost for part #696. May grabs a calculator and uses the high-low method to estimate a cost equation. What equation does she get?arrow_forwardYour firm sells home appliances at retail. When ordering washingmachines from the manufacturer, you notice the following terms listed inthe catalog:♦ List price, $400♦ Trade discounts of 25/15/5 If you take advantage of all trade discounts, find the net price you will payfor the washing machine.arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs belows Required A Required B Assume that only one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Case #1 Case #2 Case #3 Case #4 Unit sold 8,900 20,100 5,300 Sales $267,000 $319,000 $148,400 Variable expenses 124,600 221,100 Fixed expenses 85,000 179,000 76,000 Net operating income (loss)…arrow_forward
- The following data represent the inventory figures for 55-gallon fish tanks at an aquarium. *Chart Attached* (D): Calculate the value of the 88 tanks by using LIFO (in $). $__________ (E): Calculate the dollar value of the 88 tanks by using the average cost method (Round your answer to the nearest cent). $___________arrow_forwardThe Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to the Magnetic Imaging Division of Medical Diagnostics, Inc. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the average operating assets in cell B6 to $8,000,000. The ROI should now be 38% arid the residual income should now be $1,000,000. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the ROI and the residual income both increase when the average operating assets decrease. 2. Revise the data in your worksheet as follows: a. What is the ROI? b. What is the residual income? c. Explain the relationship between the ROI and the residual income?arrow_forwardPlease refer to the picture below for information. Kindly show the complete solution using MS Excel or Table. Thank you so much. Question: Using Perpetual system and LIFO method, what is the amount of inventory as of December 31? a. P59,000 b. P57,000 c. P61,600 d. P60,210arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning