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
- In the following MRP planning schedule for Item J, indicate the correct net requirements, planned-order receipts, and planned-order relesses to meet the gross requirements. Lesd time is one week. (Leave the cells blank, whenever zero (0) is required.) WEEK NUMBER 2 ITEM I 1 4 5 Gross requirenents 75 5e 70 On- hand 40 Net requirements Planned-order receipt Planned-order release Perlod 2 4 5 Grass requirements 75 50 70 Scheduled receipts Item: J ОН: 40 LT: 1 SS: 0 Q: L4L Projected available balance Net requirements Planned order receipts Planned order releasesE15-19. Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order Processing Costs 1 3,300 $90,970 2 1,650 55,412 3 4,840 132,770 4 3,080 90,090 5 2,530 76,752 6 1,320 47,410 7 2,200 68,750 Required a. Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. b. Plot the data on a scatter diagram. Using the information from representative high- and low-volume months, develop a cost-estimating equation for monthly production costs. c. What factors might have caused the difference in the equations developed for requirements (a) and (b)?If Order order size is 400, carrying cos rS0.4, rates items sold 40perday, then total costfor leyele:
- 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 following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 2 3 4 5 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory.$_______Directions: 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…
- The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 $fill in the blank 1 2 $fill in the blank 2 3 $fill in the blank 3 4 $fill in the blank 4 5 $fill in the blank 5 6 $fill in the blank 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory. $fill in the blank 7LO.4 (High-low method) Wyoming Wholesale has gathered the following data on the number of shipments received and the cost of receiving reports for the first seven weeks of 2013. Number ofShipments Received Weekly Cost ofReceiving Reports 50 $175 44 162 40 154 35 142 53 185 58 200 60 202 a. Using the high-low method, develop the equation for predicting weekly receiving report costs based on the number of shipments received.b. What is the predicted amount of receiving report costs for a week in which 72 shipments are received?1. The following information was reported for Gray Enterprises on December 31, 2020.Manufacturing Overhead Debit Credit 3,410 51,520 15,030 37,090 Double line4,010 Double line A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20 2. The following information was reported for Gray Enterprises on December 31, 2021.Manufacturing Overhead Debit Credit 2,020 56,340 15,540 31,920 Double line Double line6,860 A. What is the actual manufacturing overhead? B. What is the allocated manufacturing overhead? C. Is manufacturing overhead underallocated or overallocated? D. Prepare the adjusting entry.Journal Date Description Debit Credit Dec. 31, 20 Dec. 31, 20
- Use the table mentioned below and calculate the average monthly amount of each 3 drivers. Number of Machine Hours Purchase Orders Moves (Mhr) (PO) July 340 5400 250 Aug. 380 5200 300 Sept. 400 5800 450 Oct. 500 6200 380 Nov. 480 6000 340 Dec. 420 5600 200 Total 2520 34200 1920BUS 038 : Business Computations10. You purchase goods on an invoice dated July 27 with terms of 3/10 EOM. Determine (a) the last day of the discount period, and (b) the last day of the credit period. 11. You purchase goods on an invoice dated February 5 of a leap year, with terms of 5/10-90X. Calculate the last day of the discount period. The discount period ends 100 days (10 + 90 = 100) after the date of the invoice. February 5 is day 36. 12. For terms of 6/10, n/30, what annual rate do you pay the supplier if you fail to pay the invoice at the end of the discount period?Thank You for Completing Your F X + /player/testdriver/launch?s=997221BE-CDC7-4D8A-8F22-F1F3C9E550FD&from Launch=true Assessment | TalentCentral-Cand X slate News Orders:: Order info... Sales Revenue • Total sales revenue was $120 million in Quarter 1. • Total sales revenue in Quarter 2 decreased by $10 million compared to Quarter 1. • Sales revenue in the East was $78 million in Quarter 1. Sales revenue in the West increased by $46 million from Quarter 1 to Quarter 2. Question Arrange the sales revenue (in '000,000s) by qual and the percentages in the East and West regions. O at $160 $120 $80 CAN 25 120 65% LO 120 22% 78% 1 of 5 Ⓒ2022 S 63%