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
**This is my second time posting the first time it wasn't answered all the way, thank you.
The Volt Battery Company has forecast its sales in units as follows:
January
1,100
February
950
March
900
April
1,400
May
1,650
June
1,800
July
1,500
Volt Battery always keeps an ending inventory equal to 130 percent of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 1,430 units, which is consistent with this policy. Materials cost $12 per unit and are paid for in the month after purchase. Labor cost is $5 per unit and is paid in the month the cost is incurred. Overhead costs are $7,500 per month. Interest of $8,300 is scheduled to be paid in March, and employee bonuses of $13,500 will be paid in June.
a. Prepare a monthly production schedule for January through July.
Volt Battery Company
Production Schedule
January
February
March
April
May
June
July
Projected unit sales
1,100selected…
McGarvey Manufacturing Company had the following 12 months of data on purchasing cost and number of purchase orders.
Month
Purchasing Cost
Number of PurchaseOrders
January
$19,250
370
February
18,060
330
March
18,200
340
April
18,050
410
May
19,345
400
June
19,500
450
July
19,670
460
August
21,300
600
September
19,430
440
October
20,020
570
November
18,800
470
December
19,340
480
Required:
1. Determine the high point and the low point.
Month with high number of purchase orders
_______
Month with low number of purchase orders
_______
2. Calculate the variable rate for purchasing cost based on the number of purchase orders. (Round to the nearest cent.)$_____ per purchase order
3. Calculate the fixed monthly cost of purchasing.$_____
4. Write the cost formula for the purchasing activity showing the fixed cost and the variable rate. Round variable rate to the nearest cent.
Total purchasing cost…
The following is Cullumber Company’s income statement for the past year.
Sales revenue
$336,000
Cost of goods sold
134,400
Gross margin
201,600
Operating expenses
145,600
Operating income
$56,000
If the company wants to sell a new product that costs $49 wholesale while keeping the same markup structure, what will be the price of the new product? (Use the gross margin percentage and round final answer to 2 decimal places, e.g. 25,124.25.)
Price of the new product
$enter the price of the new product in dollars rounded to 2 decimal places
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
- Pietro expects to produce 50,000 units and sell 49,300 units. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Required: 1. Prepare a statement of cost of goods sold in good form. 2. What if the beginning inventory of finished goods decreased by 5,000? What would be the effect on the cost of goods sold?arrow_forwardSterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?arrow_forwardClick the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.arrow_forward
- Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardThe Hat Store had the following series of transactions for Year 2. Date Transaction Description January 1 Beginning inventory 45 units @ $21.50 March 15 Purchased 210 units @ $25.50 May 30 Sold 160 units @ $25.50 August 10 Purchased 275 units @ $26.50 November 20 Sold 345 units @ $40.75 Required a. Determine the quantity and dollar amount of inventory at the end of the year, assuming The Hat Store uses the FIFO cost flow assumption and keeps perpetual records. (Round your answers to 2 decimal places.)arrow_forwardAn entity uses the economic order quantity model and wishes to discover how many orders it need to place each year in order to meet its annual demand of 50,000 units. The cost of placing an order is £5 and the cost of holding a unit of inventory for year is £6. a. 177 b. 180 c. 174 d. 144arrow_forward
- 1. If last year's sales were $906,050 and a store was planning an increase in sales of 3.75% and a markdown percent of 18.25%, what is the planned markdown in dollars? (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) 2. Using the following data, calculate the planned April purchases at cost. (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) Sales $220,000 BOM Stock for April $380,000 BOM Stock for May $240,000 Markup 51% Markdowns 2.3%arrow_forwardOn March 1, a company purchased 10 footballs for $5 each. On March 11, the company purchased an additional 10 footballs for $7 each. On March 20, it sold 9 footballs for $20 each. If the company is using the averaging method, its ending inventory on March 20 would be? Question 1 A company starts the year with twenty units of inventory costing $20 each. In January, ten of these units are sold for $40 each. Then, ten new units are bought for $22 each. Shortly thereafter, ten units are sold for $50 each. Then, ten units are bought for $27 each. Finally, near the end of the year, ten units are sold for $60 each. If a weighted average (periodic) system is in use, the cost of ending inventory is: If a weighted average (perpetual) system is in use, the cost of ending inventory is: A company starts operations on October 1, Year One, holding 400 units of inventory whichfills its store. This inventory costs $10 per unit. After that, enough inventory is…arrow_forwardEddie’s Galleria sells billiard tables. The company has the following purchases and sales for 2021. Date Transactions Units Unit Cost Total Cost January 1 Beginning inventory 150 $540 $ 81,000 March 8 Purchase 120 570 68,400 August 22 Purchase 100 600 60,000 October 29 Purchase 80 640 51,200 450 $260,600 Jan. 1–Dec. 31 Sales ($700 each) 400 Eddie is worried about the company’s financial performance. He has noticed an increase in the purchase cost of billiard tables, but at the same time, competition from other billiard table stores and other entertainment choices have prevented him from increasing the sales price. Eddie is worried that if the company’s profitability is too low, stockholders will demand he be replaced. Eddie does not want to lose his job. Since 60 of the 400 billiard tables sold have not yet been picked up by the customers as of December 31, 2021, Eddie decides incorrectly to include these tables in ending inventory. He appropriately includes…arrow_forward
- The ABC co.is planning to stock new product. The ABC co.has developed thefollowing information:Annual usage = 5400 unitsCost of the product = 365 MU/unitOrdering cost = 55 MU/orderCarrying cost = 28%/year of inventory value helda) Determine the optimal number of units per order?b) Find the optimal number of orders/year?c) Find the annual total inventory cost? Please mention formulas and do it in detail so I can understand.arrow_forwardDelta’s policy is to keep 20% of next month’s sales in ending inventory. If sales in April are expected to be 5,800 units, and sales in May are expected to be 8,000 units, how many units should be produced in April? Multiple Choice 5,360 3,040 8,560 some other answer 6,240arrow_forwardGiven the following information: Annual sales in units 40,000 Cost of placing an order $58.00 Per-unit carrying costs $2.30 Existing units of safety stock 600 What is the EOQ? Round your answer to the nearest whole number. units What is the average inventory based on the EOQ and the existing safety stock? Use the rounded value of the EOQ from the previous question in your calculations. Round your answer to the nearest whole number. units What is the maximum level of inventory? Use the rounded value of the EOQ from the previous questions in your calculations. Round your answer to the nearest whole number. units How many orders are placed each year? Use the rounded value of the EOQ from the previous questions in your calculations. Round your answer to the nearest whole number. orders per yeararrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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