8. Day Mail Order Co. applied the high-low method of cost estimation to customer order data for the first four months of 2020. What is the estimated variable order filing cost component per order? Orders 1,200 1,300 1,800 Costs January P3,120 February 3,185 March 4,320 3,895 April 1,700 a. P2.00 b. P2.42 c. P2.48 d. P2.50 e. None of these; answer is
Q: following information is available to estimate customer lifetime value for a new customer: Average…
A: Customer retention is the term which is defined as company ability to retain the customers over…
Q: The S&OP team at Kansas Furniture, has received the following estimates of demand requirements: July…
A: Regular production Cost = $50 per unit Inventory Carrying cost = $25 per unit per month Opening…
Q: Cari Furniture has the following information in respect of Coffee tables for 2021: Production…
A: Introduction:- A budget is an estimate of revenue and expenses for a certain future period of time…
Q: Macdo had 150,000 units of product A on hand at January 1, 2020, costing P21 each. Purchases of…
A: Here in this question we are required to calculate cost of inventory in FIFO basis. Under FIFO…
Q: The material DX is used uniformly throughout the year. The data about annual requirement, ordering…
A: In this question, we are required to calculate Economic Order Quantity(EOQ). Economic Order Quantity…
Q: The Volt Battery Company has forecast its sales in units as follows: January 1,100 February…
A: The production schedule is used for determining the required production in any period by the…
Q: Cari Furniture has the following information in respect of Coffee tables for 2021: Production…
A: The purchase budget is prepared to estimate the units to be purchased during the period.
Q: The total purchase related cost is RO 20,000. The number of purchase orders placed is 80. The…
A: Solution 1: Activity cost driver rate = total activity cost / activity driver = 20000 / 80 = RO 250…
Q: Octopus Company provides you with the following information regarding its inventory Maximum lead…
A: a) Economic order quantity or EOQ is the optimal quantity of inventory to be ordered. EOQ helps…
Q: Production and sales estimates for March for the Robin Co. are as follows: Estimated inventory…
A: Inventory refers to the goods or items which are stored by the business either for selling or for…
Q: Bidbid Company's production budget for month of February is 37,000 units, and the Company's ending…
A: Budgeted production means how many units needs to be produced to fulfill the sales demand level and…
Q: 16. Macdo had 150,000 units of product A on hand at January 1, 2020, costing P21 each. Purchases of…
A: Under the LIFO inventory method, the latest purchases are sold first (last in first out). So the…
Q: A supplier sells Hipoint-brand pens to stationary shops. The annual demand is approximately 24,000…
A: Here in this question we are required to calculate EOQ, ordering cost and carrying cost. Economic…
Q: The S&OP team at Kansas Furniture, has received thefollowing estimates of demand…
A: There is no lost sales in both plans. Assuming that there is no limit on the number of units that…
Q: Problem 4 ECONOMIC ORDER QUANTITY. Luster Corporation presents the following data: Usage is 400…
A: Economic order quantity means the quantity to be ordered so that total inventory cost (purchase cost…
Q: The MPS for product A calls for 100 units to be completed in week 4 and 200 units in week 7 (the…
A:
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: Step 1 The total number of units manufactured is 5,025. It is obtained by adding the number of…
Q: 8. Ace Ltd. Manufactures a product and the following particulars are collected for the year ended…
A: 8. i) Formula for Re-order quantity= √2x A x P /S Where, A= Annual consumption (units) during the…
Q: Q3) _suppose that the demand for a product is 2000 per year, and the items are withdrawn uniformly.…
A: Note: As per the policy, we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit…
Q: Use the table mentioned below and calculate the average monthly amount of each 3 drivers.…
A: An average can be defined as the summation of two or more numbers and dividing the total by the…
Q: Explain THREE limiting assumptions of cost volume profit
A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…
Q: A buyer had an inventory at the beginning of the month of $120,000 and a planned EOM stock of…
A: Markup refers to the variance between the selling price and cost. It is the percentage of profit…
Q: In the following MRP planning schedule for Item J, indicate the correct net requirements,…
A: Given Gross requirement of week 2, 4, 5 is 75, 50, and 70 respectively.
Q: Wyoming Wholesale has gathered the following data on the number of shipments received and the cost…
A: High low method: Variable cost per Shipments Received = (Highest activity cost - Lowest activity…
Q: A company purchase the following item from supplier A Annual Demand 3000 Holding…
A: “Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Required: 1. Prepare a schedule showing Redwood Company's total selling cost for each order size and…
A:
Q: The following inventory date have been established for Warriors Company: Order must be placed in…
A: Hi student Since there are multiple subparts, we will answer only first three subparts.
Q: Eddie’s Galleria sells billiard tables. The company has the following purchases and sales for 2021.…
A: Units available for sale = 150 units+ 120 units +100 units + 80 units = 450 units Units sold = 400…
Q: Problem (2) XYZ corporation currently practices the following system for the procurement of an item:…
A: Economic Order Quantity EOQ=2×Annual Demand×Ordering Cost per orderHolding cost per unit
Q: For the next questions, please refer to the given data: UNIT UC Total Cost November 1 Balance 20,000…
A: Cost of goods sold is arrived at by adding up opening inventory with purchases and then sales and…
Q: Cari Furniture has the following information in respect of Coffee tables for 2021: Production…
A: Materials usage budget refers to the budget which is used in planning how much the raw materials…
Q: (a) The Dermaniaga Company has the following information available: [Syarikat Dermaniaga mempunyai…
A: Production budget shows how much units are expected to be produced in order to fulfil sales demand…
Q: Production and sales estimates for March for the Robin Co. are as follows: Estimated inventory…
A: Formula to calculate number of units expected to be manufactured:Number of units expected to be…
Q: The trailer company exspects to sell 9000 for $155 each for a total of $1,395,000 in January and…
A: The inventory formula is as follows Opening Inventory+ Additions= Closing Inventory+ Cost of goods…
Q: Q3(a) ABC Ltd. uses EOQ logic to determine the order quantity for its various components and is…
A: Economic order quantity means the number of units to be ordered so that total cost of inventory will…
Q: A buyer had an inventory of $93,000 on August 1 and a planned EOM stock of $120,000. Planned sales…
A: Given data, Planned sales=$65,000 Planned EOM=$120,000 Markdowns(MD)=$5,690 on hand=$93,000 on…
Q: Revenue expected for 2011 are: Selling price $392 per table Unit sold…
A: Revenue budget shows the amount of sales revenue expected during a period. Basis the revenue budget,…
Q: ABC Co. is selling its products to customers A, B and C. The following information is given for the…
A: Profitability statement shows the actual amount of profit or loss after subtracting all the costs…
Q: 20. Andrew, marketing clerk for Shine Agency, recorded the following information for last year:…
A: High-Low method: It is a method where fixed and variable cost is separated from the provided data.…
Q: Kaizen Furniture has the following information in respect to coffee tables for 2011: Production…
A: A budget is prepared with a view to estimate the revenues or expenses of the entity over a specific…
Q: Langer Company produces plastic items, including plastic housings for humidifiers. Each housing…
A: Production needs for october= Units to be produced x Direct material per unit (ounce) = 6300 x 19 =…
Q: Production and sales estimates for March for the Robin Co. are as follows: Estimated inventery…
A: Solution... Total sales units = 6,500 + 8,300 + 7,900 = 22,700 Ending inventory = 19,100…
Q: Average order: $ 535 Frequency of orders: 1.6 /year Average margin: 60 % markup on retail Customer…
A: Retention rate is a measurement rate. It measures the number of customers and users receiving…
Q: Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. gin by calculating the…
A: Budget refers to the financial plan for a time frame of one year and it involves the planned sales…
Q: Figure out what the Cost of Goods Sold is for the order placed for FIFO LIFO and Weighted Average…
A: Units sold = Total units available for sale - Units in ending inventory = 1,000 - 375…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Assume Will & Partners LLP has the following information on the number of sales orders received and order - processing costs for the latter half of 2022: Use the high -low method to estimate the order -processing costs if Will & Partners receives 3,500 sales orders in December (assume none of the above values are outliers) $36,000 $ 44,600 $38,400 $ 37,333 $42,000The following information relates to Unique Ltd for the year 2020: Annual Demand 408,375 units Annual cost of Holding £1.50 Annual cost of placing an order £ 500 Required:(i) Calculate the EOQ (ii) Calculate the average inventory (iii) Calculate the total annual ordering cost (iv) Calculate the total annual inventory cost (excluding the purchase cost)The following information relates to Unique Ltd for the year 2020: Annual Demand 408,375 unitsAnnual cost of Holding £1.50Annual cost of placing an order £ 500 1. Calculate the EOQ 2. Calculate the average inventory 3. Calculate the total annual ordering cost 4. Calculate the total annual inventory cost (excluding the purchase cost)
- The following information relates to Unique Ltd for the year 2020: Annual Demand 408,375 units Annual cost of Holding £1.50Annual cost of placing an order £500 Required: (i) Calculate the EOQ (ii) Calculate the average inventory (iii) Calculate the total annual ordering cos (iv) Calculate the total annual inventory cost (excluding the purchase cost)Dohini Manufacturing Company had the following 12 months of data on purchasing cost andnumber of purchase orders. Month Purchasing Cost Number of Purchase OrdersJanuary $18,860 370February 18,065 330March 19,250 370April 18,050 410May 19,345 400June 19,500 450July 19,670 460August 20,940 560September 19,430 440October 20,020 500November 18,800 470December 19,340…The S&OP team at Kansas Furniture, has received thefollowing estimates of demand requirements:July Aug. Sept. Oct. Nov. Dec.1,000 1,200 1,400 1,800 1,800 1,800 Stephanie Klein-Davis/The Roanoke Times/ AP Imagesa) Assuming one-time stockout costs for lost sales of $100 perunit, inventory carrying costs of $25 per unit per month, andzero beginning and ending inventory, evaluate these two planson an incremental cost basis: ◆ Plan A: Produce at a steady rate (equal to minimum require-ments) of 1,000 units per month and subcontract additional units at a $60 per unit premium cost.◆ Plan B: Vary the workforce, to produce the prior month’sdemand. The fi rm produced 1,300 units in June. The cost ofhiring additional workers is $3,000 per 100 units produced.The cost of layoff s is $6,000 per 100 units cut back.
- Referring to the situation in P9.2 for Garcia Home Improvement Company, consider the following expanded data at May 31, 2020. Assume Garcia uses LIFO inventory costing. Cost ReplacementCost SalesPrice Net RealizableValue NormalProfit Aluminum siding $ 70,000 $ 62,500 $ 64,000 $ 56,000 $ 5,100 Cedar shake siding 86,000 79,400 94,000 84,800 7,400 Louvered glass doors 112,000 124,000 186,400 168,300 18,500 Thermal windows 140,000 126,000 154,800 140,000 15,400 Total $408,000 $391,900 $499,200 $449,100 $46,400 Instructions a. 1. Determine the proper balance in Allowance to Reduce Inventory to Market at May 31, 2020. 2. For the fiscal year ended May 31, 2020, determine the amount of the gain or loss that would be recorded due to the change in Allowance to Reduce Inventory to Market. Prior to adjustment, the Allowance account had a balance of $27,500. b. Explain the rationale for the use of the lower-of-cost-or-market rule as it…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 material DX is used uniformly throughout the year. The data about annual requirement, ordering cost and holding cost of this material is given below: • Annual requirement: 3,400 units • Ordering cost: OMR 15 per order • Holding cost: OMR 0.70 per unit •What will be the economic order quantity (EOQ) of material DX a. 3817.254 b. 318.72 c. 381.72 d. 3187.254 ....... Answer the Question based the data given below Opening Stock 25000 Closing Stock 35000 Net purchases 130000 Manufacturing expenses 30000 What will be the inventory turnover ratio? a. 6 b. 5 c. 4.5 d. 4
- An 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. 144Use the following information to determine the changes in the following: cost of service failures (including invoice discount, rehandling cost, lost sales), and net income, and Return on Assets.Average price per order $125Gross margin per order $42Annual orders 80,000Of orders not filled correctly Rectified orders 70%With invoice discount $25With additional handling $15Orders refused 20%Warehousing cost $250,000Other operating costs $650,000Cash $1,000,000Accounts receivable $500,000Fixed assets $10,000,000Tax rate 40%Transportation cost $350,000Average inventory $700,000Interest cost $400,000Inventory Carrying Cost 10% per yearA company wishes to establish an EOQ for an item for which the annual demandis $800,000, the ordering cost is $32, and the cost of carrying inventory is 20%.Calculate the following:a. The EOQ in dollars.b. Number of orders per year.c. Cost of ordering, cost of carrying inventory, and total cost.d. How do the costs of carrying inventory compare with the costs of ordering?