+ㅁ← → Cv2.cengagenow.com/ilrn/takeAssignment/takeAssignment Main.do?invoker=&takeAssignmentSession Locator=&inprogress=falseM Gmail ► YouTubeMapsBlackboardTest #2 - Chpts 16, 17, 18, 19, 21, 2Sales and Production BudgetsVibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget:Rumble ThunderEstimated inventory (units), June 126866Desired inventory (units), June 3030857Expected sales volume (units):North Region3,6003,150South Region5,2004,500Unit sales price$145$225a. Prepare a sales budget.Product and AreaModel Rumble:North RegionSouth RegionPreviousWCengageNOWv2 | Online teachin x>68°FClearVibrant Inc.Sales BudgetFor the Month Ending June 30UnitUnitSales SellingVolume Price3,6001451455,200TotalSales522,000754.000■A ENGNextO8:25 PM4/29/2022x: CengageNOWv2 | Online teachin x +← → Cv2.cengagenow.com/ilrn/takeAssignment/takeAssignment Main.do?invoker=&takeAssignmentSession Locator=&inprogress=falseM Gmail ▸YouTubeMapsBlackboardTest #2 - Chpts 16, 17, 18, 19, 21, 2South Region5,200754,000Total8,8001,276,000Model Thunder:North Region3,150708,750South Region4,5001,012,500Total7,6501,721,250Total revenue from sales2,997,250b. Prepare a production budget.Units UnitsModel ModelRumble ThunderW>Expected units to be soldPlus desired inventory, June 30Total units requiredLess estimated inventory, June 1Total units to be produced68°FClear145225225Vibrant Inc.Production BudgetFor the Month Ending June 30▼0PreviousA ENGNextOㅁ8:25 PM4/29/2022x:

Working Notes:- Preparation of Sales Budget:- . Preparation of production budget:-

Vibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 268 66 Desired inventory (units), June 30 308 57 Expected sales volume (units): North Region 3,600 3,150 South Region 5,200 4,500 Unit sales price $145 $225 a. Prepare a sales budget.

Vibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 268 66 Desired inventory (units), June 30 308 57 Expected sales volume (units): North Region 3,600 3,150 South Region 5,200 4,500 Unit sales price $145 $225 a. Prepare a sales budget.

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

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
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.…
Open the file CVP 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 solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.
E3 4. ( I) Posted by: Grant Gould on a Web Blog Purchasing some software on Buy.com about a year ago, I found that the listed prices for the same software were different on the front page of the website ($49), on the search-all- products results page ($39), and on the search-all-computer-games page ($29). These were, in order, progressively narrower searches. II) From the Wall Street Journal: H-P has quietly begun implementing "region coding" for its highly lucrative print cartridges for some of its newest printers sold in Europe. Try putting a printer cartridge bought in the U.S. into a new H-P printer configured to use cartridges purchased in Europe and it won't work. Software in the printer determines the origin of the ink cartridge and whether it will accept it. Please use the two examples above to comment on the following: (Please be very specific in applying the two examples above for the discussion of the comments below) i. Price discrimination increases a seller’s profits. ii.…
Instructions for Excel Spreadsheet Assignment #2Preliminary Setup InformationYour company manufactures and sells computer memory chips. You are part of the department whose job it is to figure out how many chips you should produce and sell. Let x represent the number (in millions) of chips that you plan to produce and sell. Your marketing department has figured out that if you produce x million chips then the selling price (in dollars) you must charge for each chip is given by the functionp(x) = 150-2x. Your production department has figured out that if you produce x million chips then the cost of production (in millions of dollars) will be given by the function C(x) = 50 + 40xYour tax department has figured out that you should expect to pay 10% tax on any profits. The tax (in millions of dollars) on a profit of y millions of dollars will be given by the functionT( y) = 0.1yExplanation of what you are to do on the Excel spreadsheetNOTE: You will not get credit for your work if you just…
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.
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…
Data 1-2-3 is a top-selling electronic spreadsheet product. is about to release version 5.0. It divides its customers into two groups: new customers and upgrades customers (those who previously purchased Data 1-2-3, 4.0, or earlier versions). Although the same physical product is provided to each customer group, sizable differences exist in selling prices and variable marketing costs: New Customers Upgrade Customers Selling price $225 $125 Variable costs Manufacturing $30 $30 Marketing 65 95 15 45 Contribution margin $130 $80 The fixed costs of Data 1-2-3 5.0 are $16,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers.…
You are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price. Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Price
The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to the Magnetic Imaging Division of Medical Diagnostics, Inc. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the average operating assets in cell B6 to $8,000,000. The ROI should now be 38% arid the residual income should now be $1,000,000. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the ROI and the residual income both increase when the average operating assets decrease. 2. Revise the data in your worksheet as follows: a. What is the ROI? b. What is the residual income? c. Explain the relationship between the ROI and the residual income?
Give typing answer with explanation and conclusion You are given the following information on a Company - ROAop = 10%, tc = 30% and rd = 5% if D/EV = 30%, what is ROE = ? Question 21 options: 8.05% 8.50% 10.00% 15.00% the answer is 8.5% but i dont understand how to get there can someone show me the work and break it down
Design a Moore binary sequence detector using D FFs that functions as a vending machine for coffee with the following specifications:a. The machine only accepts P5 and P10 peso coinsb. Coffee is worth P25c. The machine is not capable of dispensing change; the change will be credited for the next purchase