Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 7, Problem 8R
Reset the November 20 purchase to 150 units, including column G. To test your formulas, suppose that Del had sold 600 units rather than 500. Sales now total $384,000. The extra units sold come from the May 13 purchase (25 units) and the November 20 purchase (75 units). Change cell B17 to 600 and cells D32 through G32 to $384,000. Alter columns E, F, and G in the Data Section to reflect the change. Your formulas should automatically redo the Calculations and Answer sections. Print the results again.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
For 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?
Create a two-variable data table as follows to provide the comparison that Liam requests:
a)In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Liam wants to compare the monthly payments.
b) Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.
Find the final price of a good that cost 8,500. It was MARKED UP by 30% then marked down by 38% and finally marked up by 65%.
Present data in table form and determine the final selling price with the fiven column data.
(Base in Markup/markdown, % decimal, multiplier, and selling price)
Chapter 7 Solutions
Excel Applications for Accounting Principles
Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Prob. 3RCh. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - What changes would have taken place if Dels...Ch. 7 - Suppose Dels purchase prices had remained...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Reset the November 20 purchase to 150 units,...Ch. 7 - Click the Chart sheet tab. On the screen is a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- SOLVE STEP BY STEP IN DIGITAL FORMAT Instructions. Solve the following problems using the Simple Interest formula.Simple interest.Formula to calculate Simple InterestI = Cni1. Calculate the Commercial Simple Interest of 2,700 for 5 months at 8%.2. Calculate the Commercial Simple Interest of 7,500 for 63 days at 9%.arrow_forwardHistorical data show that customers who download music from a popular Web service spend approximately $20 per month, with a standard deviation of $3. Assume the spending follows the normal probability distribution. Find the probability that a customer will spend at least $18 per month. How much (or more) do the top 7% of customers spend? What is the probability that a customer will spend at least $18 per month? 0.7475 (Round to four decimal places as needed.) How much do the top 7% of customers spend? (Round to the nearest cent as needed.)arrow_forwardThe following information is for Bonnies Buds, a nursery and floral shop, for the month ended May 31, 2012: Click the Chart sheet tab on the FMERCH3 file. You will see a chart depicting the five-month trend in sales, gross profit, and net income. What favorable and unfavorable trends do you see in this month-to-month comparison? Comment on any unusual changes. When the assignment is complete, close the file without saving it again. Worksheet. Your boss would prefer to have the balance sheet shown before the income statement and the statement of retained earnings. Please make this change on the FMERCH3 file. Preview the printout to make sure that the worksheet will print neatly on two or three pages, and then print the worksheet. Save the completed file as FMERCHT. Chart. Using the FMERCH3 file, prepare a 3-D pie chart that shows the amount of each of the selling expenses in June. No Chart Data Table is needed. Select A57 to A62 as one range on the worksheet to be charted and then hold down the CTRL key and select E57 to E62 as the second range. Enter your name somewhere on the chart. Save the file again as FMERCH3. Select the chart and then print it out.arrow_forward
- Benson Corporation operates three investment centers. The following financial statements apply to the investment center named Bowman Division. BOWMAN DIVISION Income Statement For the Year Ended December 31, Year 2 $107,280 58,475 48,805 Sales revenue Cost of goods sold Gross margin Operating expenses Selling expenses Depreciation expense Operating income Nonoperating item Loss on sale of land (2,680) (4,055) 42,070 (4,600) $ 37,470 Net income BOWMAN DIVISION Balance Sheet As of December 31, Year 2 Assets $ 12,662 40,416 37,700 90,378 9,100 Cash Accounts receivable Merchandise inventory Equipment less accumulated depreciation Nonoperating assets Total assets $190,256 Liabilities Accounts payable Notes payable Stockholders' equity 9,457 69,000 $ Common stock 79,000 32,799 Retained earnings Total liabilities and stockholder's equity $190,256 Required c. Calculate the ROI for Bowman. d. Benson has a desired ROl of 13 percent. Headquarters has $91,000 of funds to assign to its investment…arrow_forwardSuppose that the base market is 500,000 out of 10M population, determine the net sales given the following. Awareness is 55%, Trial is 30%, Availability is 100%. Purchase frequency is 30.2%, Units bought per purchase is 4.25, price is 25.50 per unit and cannibalization rate of 40%. Net sales is ______. Round off to 2 decimal placesarrow_forwardAn office supply store adds a $2.50 markup to calculators and sells them for $6.95. (a) What is the cost (in $) of the calculators? $ (b) What is the percent markup based on cost? (Round your answer to the nearest tenth of a percent.) %arrow_forward
- Fill out the following MRP record. The lot size is 60 units and the units on hand are 100 units. The lead time between order placement and receipt is 1 periods. How would the MRP record change once the period 1 passed and it is period 2 currently? Provide a MRP record starting on period 2.arrow_forwardDirections: Show complete solutions. Take a picture of your solutions and paste in word. Submit the word file version to my email no later than 10:30am today. Thanks. Problem 1: Quarry Company, a manufacturer of small tools, provided the following information for the year ended December 31, 2020. Inventory at December 31, based on physical count – P1,750,000 Accounts payable at December 31 – P1,200,000 Net sales – P8,500,000 Additional information: Included in the physical count were tools billed to a customer FOB shipping point on December 31, 2020. These tools had a cost of P28,000 and were billed at P35,000. The shipment was in loading dock waiting to be picked up by the common carrier. Goods in transit from a vendor to Quarry Company on December 31, 2020. The invoice cost was P50,000 and the goods were shipped FOB shipping point on December 29, 2020. Work in Process inventory costing P20,000 was sent to an outside processor for plating on December 30, 2020. Tools returned by…arrow_forwardSolve. Show the system of equations used and show your work on solving the system: A company wants to advertise its product in a certain magazine. The magazine offers two ad plans: Plan A: 6 full-page ads and 6 half-page adds will cost $2550 Plan B: 8 full-page ads and 4 half-page ads will cost $2800 Find: The cost of a full-page ad b. The cost of a half-page ad a.arrow_forward
- The Elberta Fruit Farm of Ontario has always hired transient workers to pick its annual cherry crop. Janessa Wright, the farm manager, just received information on a cherry picking machine that is being purchased by many fruit farms. The machine is a motorized device that shakes the cherry tree, causing the cherries to fall onto plastic tarps that funnel the cherries into bins. Ms. Wright has gathered the following information to decide whether a cherry picker would be a profitable investment for the Elberta Fruit Farm: a. Currently, the farm is paying an average of $250,000 per year to transient workers to pick the cherries. b. The cherry picker would cost $540,000. It would be depreciated using the straight-line method and it would have no salvage value at the end of its 5-year useful life. c. Annual out-of-pocket costs associated with the cherry picker would be: cost of an operator and an assistant, $80,000 insurance, $4,000; fuel, $12,000, and a maintenance contract. $15,000. Click…arrow_forwardThe following time series shows the sales of a particular product over the past 12 months. Construct a time series plot. What type of pattern exists in the data? Use α = 0.3 to compute the exponential smoothing values for the time series. Use trial and error to find a value of the exponential smoothing coefficient α that results in a relatively small MSE.arrow_forwardYou have been pricing an MP3 player in several stores. Three stores have the identical price of $600. Each store charges 18 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C uses the previous balance method. Assume you purchased the MP3 player on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Finance Charge Store A Store B Store Carrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Accounting Changes and Error Analysis: Intermediate Accounting Chapter 22; Author: Finally Learn;https://www.youtube.com/watch?v=c2uQdN53MV4;License: Standard Youtube License