add the year 2022 data series to the chart (using cells b3:d7) SAM skylar kilby-barber: Excel Module 7 SAM Exam - Google ChromeA samcp.cengage.com/AssignmentTake/Exam?assignmentld=71181576&resultld=61670539&instld=a1cf5ff9-50e6-4f35-8283-03b9980be826&pid=7292042&ts=637847154069432651&uid=SAM&signature=vuriLWux%2byQcalnl%2fACTCttSZ91%3dE Task 11 of 47>Assignment: Excel Module 7 SAM ExamTask: EX10830 Add a data series to a chart.Attempts RemainingSubmitAutoSave O OffA 6. 2, ;PB Sample Budget Workshops.xlsx - ExcelChart ToolsSign in国FileHomeInsertPage LayoutFormulasDataReviewViewDesignFormatP Tell me what you want to do合 ShareP CommentsE. AutoSum -- A A= =ab Wrap TextGeneralCalibriO Fill-Conditional Format asFormattingPasteВI U -- A -= E E Merge & Center2$% 9 58 99CellInsert Delete FormatSort & Find &TableStylesO ClearFilter Select -ClipboardFontAlignmentNumberStylesCellsEditingChart 1ADEGKLMNRUVYPrecision BuildingCost Forecast by City$70,0001.$60,000Cost Forecasts by City - Kitchens2$50,0003CityYear 2020 Year 2021Year 2022$40,000$44,000$65.0004 Atlanta, GA$43,000$45.0005 Boston, MA6 Denver, CO7 Honolulu, HI$60,000$38,000I$51,500$67.000I$43,000I$57,500$30,000$40,000I$55,000$20,00089 Based on 150 sg. ft. kitchen$10,0001011$012Year 2020Year 2021131 Series1 1 Series2 1 Series3Series414151617Task Instructions1819Add the Year 2022 data series to the chart (using cells20B3:D7).212222ForecastsReady囲100%7:53 PMO Type here to search3/25/2020

F Precision Building Cost Forecast by City S70,000 S60,000 Cost Forecasts by City - Kitchens 2 S50,000 City 4 Atlanta. GA 5 Boston, MA 6 Denver, CO 7 Honolulu, HI Year 2020 Year 2021 Year 2022 $44.000 S65,000 $40,000 Is55,000 S40,000 |$43,000 S60,000 $38.000 $51.500 IS45.000 S67,000 $43,000 $57,500 S30,000 S20,000 9 Based on 150 sq. ft. kitchen S10,000 10 11 12 Year 2020 Year 2021 13 Series1 Series2 Series3 Series4 14 15 16 17 Task Instructions 18 19 Add the Year 2022 data series to the chart (using cells B3:D7). 20 21 22 Forecasts

F Precision Building Cost Forecast by City S70,000 S60,000 Cost Forecasts by City - Kitchens 2 S50,000 City 4 Atlanta. GA 5 Boston, MA 6 Denver, CO 7 Honolulu, HI Year 2020 Year 2021 Year 2022 $44.000 S65,000 $40,000 Is55,000 S40,000 |$43,000 S60,000 $38.000 $51.500 IS45.000 S67,000 $43,000 $57,500 S30,000 S20,000 9 Based on 150 sq. ft. kitchen S10,000 10 11 12 Year 2020 Year 2021 13 Series1 Series2 Series3 Series4 14 15 16 17 Task Instructions 18 19 Add the Year 2022 data series to the chart (using cells B3:D7). 20 21 22 Forecasts

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Nice-Fit is a (fictional) small business producing outfits for costume parties and specialoccasions. Custom designs can be tailored to a customer’s request. Tom and Ann are theowners of the company and source all the fabric, design the outfits and make the costumesthemselves. Tom and Ann keep spreadsheets with information on the material purchased andcostumes made, but they find it difficult to keep track of their products, raw materials, andsales. The raw materials are supplied from a fabric company in India, and the production takesplace in a manufacturing company in China. The clothing is sold at local weekend markets,sold, or rented through costume hire shops, and sold at their physical store. Tom and Annreceive a small percentage of the sales and rentals of their costumes from the hire shops.They have no information on customers other than those who request custom designsdirectly from them. In 2020, the Covid-19 pandemic had a major impact on global economies,businesses and how we…
Xpress Technologies offers complete web design, programming, implementation, and hosting services for customers. Xpress prices their services by the project and categorizes each customer request into one of three possible project categories: simple HTML design, requires Java/Flash coding, requires secure transaction capabilities. Xpress charges $3000 for each simple HTML design project, $5000 for each Java/Flash coding project, and $8000 for each project requiring secure transaction capabilities. Xpress has two types of employees that it assigns to these projects: graphic designers who make $32/hour and programmers who make $36/hour. The company currently has two graphic designers and four programmers; each employee can work up to a total of 40 hours per week. Xpress estimates that a simple HTML project will require 2 hours from the graphic designers and 4 hours from the programmers; projects requiring Java/Flash coding require 5 hours from the graphic designers and 6 hours from the…
Please answer parts d,e,f,g,h,i of the the word problem below. The answers for parts a, b,c are written below so could you continue to answer the questions.
Problem: Acme Manufacturing produces widgets on an assembly line. The assembly process has five tasks, each with its own processing time: Task Processing Time (Seconds) A 10 B 8 C 12 D 9 E 7 drive_spreadsheetExport to Sheets Acme currently has two workers assigned to the assembly line, and they work simultaneously. The company wants to improve line efficiency and reduce waste. Objective: Balance the assembly line by assigning tasks to each worker in a way that minimizes idle time and maximizes output.
SportTech Events: SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information, such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create an ERD from the information described above and then to create a normalization structure in 3NF.
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving should be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs P10,000 and each training program on problem-solving costs P8,000. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost. Graph the feasible…
As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…
As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. Graph the feasible region.…
As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost
Can you tell me how to solve this problem or show me how to solve it
No need generalized answer ok need Correct Solution. PM.348.WC1 Project Risk Management Pls. answer this ;( INSTRUCTIONS Create a “starter” risk register using EXCEL for the two projects (A and BB described below. Include at least 6 risks for project A and at least 8 risks for project B. Project A Description Building a garden shed. This includes the design of the shed, sourcing all the materials required for construction, and putting all of the various pieces together to get the finished shed. Outcome A finished garden shed. Proposed Tasks There are going to be certain tasks that depend on others. You’re going to need to: • Get a set of blueprints for the shed and clear and prepare the area for construction • Source all of the materials for the construction • Prepare the foundation and start constructing the beams of the floor • Lay the floorboards • Construct the frames of the walls and raise and fit each of them • Frame the roof and attach the roofing • Fit in all the siding for…