Could you help me find the blanks * My HomeCengageNOWv21 Online teachin xre to enter cengagenow h X-Assignment/takeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator=&inprogress%3falseI CalculatorLearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The companybegan operations on January 1, 20Y1, and is planning for 2OY2, its second year of operations, by preparing budgets from its master budget.The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factoryoverhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgetedincome statement showing a prediction of net income for 20Y2.You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets.Sales BudgetThe sales budget often uses the prior year's sales as a starting point, and then sales quantities are revised for various factors such as plannedadvertising and promotion, projected pricing changes, and expected industry and general economic conditions. LearnCo has completed reviewing itsprior year's sales and has prepared the following sales budget.After reviewing LearnCo's sales budget, you note that three numbers have been omitted. The company's controller has told you that the units sold forthe Basic and Deluxe models are expected to be the same. Fill in the missing amounts.LearnCoSales BudgetFor the Year Ending December 31, 20Y2Unit SalesUnit SellingTotalProductVolumePriceSalesBasic Abacus$6$216,000Deluxe Abacus504,000Totals72,000$720,000Check My Work 5 more Check My Work uses remaining.6.7:05 PM4/18/202F5F6F7F8 * CengageNOWv2 | Online teachin x +enter cengagenow h X My Homeignment/takeAssignmentMain.do?invoker=D&takeAssignmentSessionLocator%3D&inprogress%3DfalseCalculatorProduction BudgetThe production budget should be integrated with the sales budget to ensure that production and sales are kept in balance during the year. Theproduction budget estimates the number of units to be manufactured to meet budgeted sales and desired inventory levels.You note that LearnCo has omitted six numbers from the following production budget and fill in the missing amounts. You may need to use numbersfrom the sales budget you prepared.LearnCoProduction BudgetFor the Year Ending December 31, 20Y2Units BasicUnits DeluxeExpected units to be sold (from Sales Budget)Desired ending inventory, December 31, 20Y21,0003,000Total units availableEstimated beginning inventory, January 1, 20Y2(1,050)(2,100)Total units to be producedFeedbackCheck My WorkBe sure to include the expected units to be sold for each model from the Sales Budget. Then review the preparation of the production budgetand how the amounts are computed,Check My Work 5 more Check My Work uses remaining,7:04/18F5F6|F7F8

Sales budget determines the units to be sold on the basis of past period trends. The forecasting of…

LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of Learno in preparing the 2012 budgets.

LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of Learno in preparing the 2012 budgets.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter25: Segment Income Statement (dept)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

I need this( https://www.chegg.com/homework-help/top-quality-appliance-long-beach-purchased-franchise-top-qua-chapter-9-problem-1cpp-solution-9780134486833-exc ) problem solved for requirment 1 only. I can not apload more than one picture thats why I send half of it from website and other half in picture. Thank you.
Further info is in the attached images For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50. Thank you!
Required information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…
You want to add a new Product and Services entry to your client's QuickBooks Online company. The service is installation of a server that doesn't include the cost of the hardware. Here are some steps for getting the job done. 1. Select the Gear icon, select Products and Services, then select New2. _____________________________________________3. In the Name field, type Server installation4. In the Sales information field, type Server installation5. Sale price/rate is $12506. In the Income Account drop-down, select Service/Fee Income7. Select Save and close Which option correctly completes Step 2? A. Select Product B. Select Inventory C. Select Service D. Select Non-inventory E. Select Bundle
I need help filling in my spreadsheet and I have looked up in the library but everyone's answer are coming out wrong. Can you please help me because this is due tomorrow. Company Accounting Workbook Template Spreadsheet https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Company%20Accounting%20Workbook%20Template.xlsx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513 Accounting Data Appendix Word Document. https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Accounting%20Data%20Appendix%201.docx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513
Open the file VARCOST from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the completed file as VARCOST2. Print the worksheet when done. Also print your formulas. Check figure: Absorption income (cell C31), 768,000.
Customer Value, Strategic PositioningAdriana Alvarado has decided to purchase a personal computer. She hasnarrowed the choices to two: Drantex (ad Confiar. Both brands have thesame processing speed, 6.4 gigabytes of hard-disk capacity, two USBports, and a DVDRW drive, and each comes with the same basic softwaresupport package. Both come from mail-order companies with goodreputations. The selling price for each is identical. After some review,Adriana discovers that the cost of operating and maintaining Drantexover a 3-year period is estimated to be $300. For Confiar, the operatingand maintenance cost is $600. The sales agent for Drantex emphasizedthe lower operating and maintenance costs. The agent for Confiar,however, emphasized the service reputation of the product and thefaster delivery time (Confiar can be purchased and delivered 1 weeksooner than Drantex). Based on all the information, Adriana has decidedto bur Confiar. Required:1. What is the total product purchased by Adriana?2.…
Question attacheed in screenshot thank sfor the help greatly appreicated oeipt234p2o3i5po2i35po23i5p2o3i52po 5i3po2ip3o5i2p3oi2p
BE5.5 - Using Excel to Evaluate a Make-Versus-Buy Decision Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Grunar Industries produces the component parts needed for its popular non-commercial-use drones. One of the key parts has become more costly to produce than first planned, however, so management is considering outsourcing that part. If the company decides not to manufacture this part, a portion of its fixed manufacturing overhead costs would continue. The costs to produce one such part internally and to purchase on part from the suppler are given here. Complete the schedule to support the decision of whether to make or buy the part. Relevant Costs to Make Relevant Cost to Buy Costs to produce internally…
What are 2 ways to add a customer to QuickBooks Online? A. Sales > Customers > Add New B. + New > Add Customer C. Sales > All Sales D. Gear icon > Add Customer Gear icon > Import Data
Please,just solve the Queestion BE12-10>>Iam up load for you 2 pic: the pic one is Question BE12-9MAYBE YOU NED IT. The pic 2 is the question I need the help.
TechPro offers instructional courses in e-commerce website design. The company holds classes in a building that it owns. Identify each of TechPro’s costs below as (a) variable or fixed and (b) direct or indirect by selecting the appropriate dropdowns. Assume the cost object is an individual class. Variable or Fixed Direct or Indirect 1. Instructional manuals for students 2. Advertising Fixed Indirect 3. Salesperson salary 4. Sales commissions 5. Computer printer ink 6. Depreciation on classroom building