Kindly answer the question Raw materials Inventory:Noeled Products Company produces a special line of products. As of December 21, 2020, the Post-closing Trial Balance is seen below:Material S5 units4,000Material RMaterials required per unit of finished productBeginning InventoryEnding InventoryUnit Costs3 units2,2001,3004,600P30CashP150.000Accounts Receivable220,000P10P146/unitproducedInventories592000Direct laborOther Current Assets23,000Property, Plant and EquipmentAccumulated DepreciationAccounts PayableTaxes PayableCurrent Portion of Long-term DebtLong-term DebtOrdinary SharesRetained Earnings2,475,000Overhead is estimated as follows:P850,000140,000156,00083,000Variable:Indirect Materials and suppliesMaterials HandlingP5.85/unit producedP9.07 per unit5.07 per unit576,000Other Indirect Labor350,000Fixed:Supervisor laborMaintenance & RepairPlant AdministrationUtilities1,305,000P175.00085,000173.00087,000280,00043,000117,000The following information is also available for the preparation of the Master Budget for 2021:DepreciationInsuranceProperty TaxesOtherEstimated Sales:Units6,400P80041,000Price per unitFinished Goods Inventory:BeginningEnding| Work In ProcessMarketing and Administrative Expenses arebudgeted as follows:Variable Marketing Costs:Sales Commission900 units @P5001.000 unitsP40.625 per unit soldOther marketing costsFixed Marketing Costs:Sales SalariesAdvertisingOtherNONEP16.250 per unit soldP100,000193,00078,000Administrative Costs (all fixed)Administrative SalariesData processing servicesLegal and other professional feesDepreciation – building, furniture andequipmentTaxes – other than incomeP254,000103,000180,00094,000160,00026,000Other RequiredPropose a Master Budget Plan for Noeled Products Company for the year ending December 31, 2021which includes1. Sales Budget2. Production Budget in units3. Raw Materials Purchases Budget4. Direct Labor Budget5. Overhead Costs Budget6. Budgeted Cost of Goods Sold7. Marketing and Administrative Expense Budget8. Cash Budget9. Budgeted Income Statement – round off the interest expense and income tax to nearest wholenumber)10. Budgeted Statement of Financial Position (support your figures with computations they will begraded)

Hi student Since there are multiple subparts, we will answer only first three subparts.

Answered: Required Propose a Master Budget Plan…

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter6: Cost Of Goods Sold And Inventory

Section: Chapter Questions

Problem 70APSA: Inventory Costing and LCM Ortman Enterprises sells a chemical used in various manufacturing...

See similar textbooks

Similar questions

Comprehensive The following information for 2019 is available for Marino Company: 1. The beginning inventory is 100,000. 2. Purchases returns of 4,000 were made. 3. Purchases of 300,000 were made on terms of 2/10, n/30. Eighty percent of the discounts were taken. 4. At December 31, purchases of 20,000 were in transit, FOB destination, on terms of 2/10, n/30. 5. The company made sales of 640,000. The gross selling price per unit is twice the net cost of each unit sold. 6. Sales allowances of 6,000 were made. 7. The company uses the LIFO periodic method and the gross method for purchase discounts. Required: 1. Compute the cost of the ending inventory before the physical inventory is taken. 2. Compute the amount of the cost of goods sold that came from the purchases of the period and the amount that came from the beginning inventory.
Webster Company adopted do liar-value LIFO on January 1, 2019. Webster produces three products: X, Y, and Z. Websters beginning inventory consisted of the following: During 2019, Webster had the following purchases and sales: Required: 1. Compute the LIFO cost of the ending inventory assuming Webster uses a single inventory pool. Round cost index to 4 decimal places. 2. Compute the LIFO cost of the ending inventory assuming Webster uses three inventory pools. Round cost indexes to 4 decimal places.
Inventory Costing Methods On June 1, Welding Products Company had a beginning inventory of 210 cases of welding rods that had been purchased for S88 per case. Welding Products purchased 1,150 cases at a cost of $95 per case on June 3. On June 19, the company purchased another 950 cases at a cost of $112 per case. Sales data for the welding rods are: Welding Products uses a perpetual inventory system, and the sales price of the welding rods was $130 per case. Required: 1. Compute the cost of ending inventory and cost of goods sold using the FIFO method. 2. Compute the cost of ending inventory and cost of goods sold using the LIFO method. 3. Compute the cost of ending inventory and cost of goods sold using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Assume that operating expenses are $21,600 and Welding Products has a 30% tax rate. How much will the cash paid for income taxes differ among the three inventory methods? 5. CONCEPTUAL CONNECTION Compute Welding Products' gross profit ratio (rounded to two decimal places) and inventory turnover ratio (rounded to three decimal places) under each of the three inventory costing methods. How would the choice of inventory costing method affect these ratios?
Inventory Pools Stone Shoe Company adopted dollar-value LIFO on January 1, 2019. The company produces four products and uses a single inventory pool. The companys beginning inventory consists of the following: During 2019, the company has the following purchases and sales: Required: 1. Compute the dollar-value LIFO cost of the ending inventory. Round the cost index to 4 decimal places and all other amounts to the nearest dollar. 2. Next Level By how much would the companys gross profit differ if it had used four pools instead of a single pool?
Refer to RE22-2. Assume the pretax cumulative effect adjustment is 50,000. Prepare the journal entry that Heller Company would make at the beginning of 2020 to record the cumulative effect of the change from LIFO to FIFO. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
ENDING INVENTORY COSTS Danny Steele owns a small specialty store, named Steeles Storeroom, whose year-end is June 30. Determine the total amount that should be included in Steeles Storerooms year-end inventory. A physical inventory taken on June 30 reveals the following: Cost of merchandise on the showroom floor and in the warehouse 42,600 Goods held on consignment (consignor is Quality Manufacturer) 7,600 Goods that Steeles Storeroom, as the consignor, has for sale at the location of Midtown Galleria 8,300 Sales invoices indicate that merchandise was shipped on June 28, terms FOB shipping point, delivered at buyers receiving dock on July 6 4,350 Sales invoices indicate that merchandise was shipped on June 26, terms FOB destination, delivered at buyers receiving dock on July 1 2,800
Reese Manufacturing Company manufactures and sells a limited line of products made to customer order. The company uses a perpetual inventory system and keeps its accounts on a calendar year basis. A 6-column spreadsheet is presented on page 1100. Additional information needed to prepare the income statement and schedule of cost of goods manufactured is as follows: REQUIRED 1. Prepare an income statement and schedule of cost of goods manufactured for the year ended December 31,20--. 2. Prepare a statement of retained earnings for the year ended December 31,20--. 3. Prepare a balance sheet as of December 31, 20--. 4. Prepare the adjusting, closing, and reversing entries.
Cost of goods sold Pine Creek Company completed 200,000 units during the year at a cost of 3,000,000. The beginning finished goods inventory was 25,000 units at 310,000. Determine the cost of goods sold for 210,000 units, assuming a FIFO cost flow.
Prepare a cost of goods sold budget for MacLaren Manufacturing Inc. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 548,000; beginning inventory of direct materials, 36,000; and ending inventory of direct materials, 23,000. Totals from other budgets included:
XYZ Co. has the following information: Inventory at 1st Jan 2020 Inventory at 31st Dec 2020 Raw Materials Inventory OMR 20,000 OMR 30,000 Work in Process Inventory OMR 18,000 OMR 15,000 Finished Goods Inventory OMR 30,000 OMR 20,000 Additional information for the year is as follows: Raw materials purchases OMR 100,000 Direct labor OMR 75,000 Manufacturing overhead applied OMR 85,000 Manufacturing overhead Actual OMR 80,000 Indirect materials OMR 0 Compute the adjusted cost of goods sold.
The following information is taking from Wei Min Enterprise for the year ended 31December 2020: Particulars RM Inventory at 1 January 2020:Raw materialsWork in progressFinished goods 25,40031,10023,260Purchases : raw materials 91,535Carriage on raw materials 1,960Direct labour 84,208Office salaries 33,419Rent 5,200Office lighting and heating 4,420Depreciation:Works machineryOffice equipment 10,2002,300Sales 318,622Factory fuel and power 8,120 Prepared by: Puan Siti Nor Junita Mohd Radzi Additional information:i. Rent is to be apportioned: factory 3⁄4; office 1⁄4ii. Inventory at 31 December 2020 was:a. Raw materials RM28,900b. Work in progress RM24,600c. Finished goods RM28,840Required: b) Prepare statement of comprehensive income for the year ended 31 December 2020.
On December 28, 2020, INDIGO Company purchased goods costing ₱500,000. The terms were FOB destination. Some of the costs incurred in connection with the sale and delivery of the goods were packaging for shipment ₱10,000, shipping₱15,000, and special handling charges ₱25,000. These goods were received on December 31, 2020. On December 31, 2020, what total cost for these goods should be included in inventory?

SEE MORE QUESTIONS

Recommended textbooks for you

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

College Accounting, Chapters 1-27

Accounting

ISBN:

9781337794756

Author:

HEINTZ, James A.

Publisher:

Cengage Learning,

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

SEE MORE TEXTBOOKS

Required Propose a Master Budget Plan for Noeled Products Company for the year ending December 31, 2021 which includes 1. Sales Budget 2. Production Budget in units 3. Raw Materials Purchases Budget