Microsoft Office Assignments

/in /by

Aspen Falls Firefighting Equipment Inventory

Eq ui

pm en

t S ta

tis tic

s Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in

Supply Item

Cost

Each Type Category

Supply

Level Check Supplier

146 Coil Headphones $30 Radio Communication Level OK Cost OK 190 Radio Strap/Holder $45 Radio Communication Level OK Cost OK

3 Retractable Mic Keeper $20 Radio Communication Order Cost OK 41 Leather Radio Holder $25 Radio Communication Level OK Cost OK 20 10″ Zipper Boots $320 Boots Footwear Level OK Check new supplier 21 Leather Fire Boots $340 Boots Footwear Level OK Check new supplier 26 Rubber Lug Boot $109 Boots Footwear Level OK Cost OK 27 Rubber Fire Boots $169 Boots Footwear Level OK Cost OK 28 Rubber Bunker Boots $129 Boots Footwear Level OK Cost OK 10 Hazmat Boot $149 Boots Footwear Level OK Cost OK 25 Fire Gloves $89 Gloves Outerwear Level OK Cost OK 27 Proximity Gear Gloves $124 Gloves Outerwear Level OK Cost OK

9 Extrication Gloves $77 Gloves Extrication Gear Order Cost OK 34 Rescue Glove Liners $39 Gloves Outerwear Level OK Cost OK 17 Extrication Coat $223 Coat Extrication Gear Level OK Cost OK 14 Extrication Pants $189 Pants Extrication Gear Level OK Cost OK 11 Extrication Coveralls $359 Coveralls Extrication Gear Level OK Check new supplier

9 Gas Mask $259 Safety Safety Equipment Order Cost OK 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK

13 Respirator $369 Safety Safety Equipment Level OK Check new supplier 19 Coverall with Hood $159 Coveralls Outerwear Level OK Cost OK 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK 10 Chemical Overboot $52 Boots Footwear Level OK Cost OK 10 Haz-Mat Boots $89 Boots Footwear Level OK Cost OK 57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK 10 Helmet $229 Helmet Outerwear Level OK Cost OK 51 Structural Fire Helmet $179 Helmet Outerwear Level OK Cost OK 25 Helmet with Eye Shield $339 Shield Safety Equipment Level OK Check new supplier

8 Megaphone $79 Megaphone Communication Order Cost OK 53 Barrier Tape $12 Tape Traffic Level OK Cost OK 18 Fire Pants $649 Pants Outerwear Level OK Check new supplier 19 Fire Coat $989 Coat Outerwear Level OK Check new supplier 25 Proximity Coat $1,299 Coat Outerwear Level OK Check new supplier 17 Proximity Pants $1,059 Pants Outerwear Level OK Check new supplier 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK 87 Rope Gloves $32 Gloves Outerwear Level OK Cost OK 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK 35 EMS Jacket $399 Coat Outerwear Level OK Check new supplier 47 EMS Pants $289 Pants Outerwear Level OK Cost OK 89 Breakaway Vest $29 Vest Outerwear Level OK Cost OK 15 Mesh Vest $17 Vest Outerwear Level OK Cost OK 25 Mesh Traffic Vest $29 Vest Outerwear Level OK Cost OK 89 Reflective Nylon Vest $11 Vest Outerwear Level OK Cost OK 16 Handheld Remote Siren $289 Siren Traffic Level OK Cost OK 19 Siren $189 Siren Traffic Level OK Cost OK 27 Traffic Baton $19 Baton Traffic Level OK Cost OK 37 Flare Beacon Kit $305 Light Traffic Level OK Check new supplier 90 Flares with Stands $99 Light Traffic Level OK Cost OK 26 Traffic Flashlight $18 Light Traffic Level OK Cost OK 56 Night Barrier Tape $15 Tape Traffic Level OK Cost OK 17 Water Rescue Kit $119 Safety Water Rescue Level OK Cost OK

Eq ui

pm en

t S ta

tis tic

s

Lastname_Firstname_e04_Fire_Equipment.xlsx Equipment

Page 1 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Text Box
In the student’s electronic file, check for the following item(s): 1. Insert SUM and AVERAGE functions 2. Insert MAX and MIN functions 3. Insert IF function in columns F and G 4. Freeze rows 1 through 11 5. Create Excel table and add Total row 6. Convert Excel table to a range 7. Format large worksheets to print
Skills for Success
Text Box
Merge B3:D9 and change orientation
Skills for Success
Line
Skills for Success
Text Box
Apply custom formats and data bars
Skills for Success
Line
Skills for Success
Text Box
Find and replace words
Skills for Success
Line

 

Quantity in

Supply Item

Cost

Each Type Category

Supply

Level Check Supplier

38 Water Rescue Vest $99 Safety Water Rescue Level OK Cost OK 4 Water Tether System $59 Safety Water Rescue Order Cost OK

18 Wildfire Helmet $59 Helmet Outerwear Level OK Cost OK 17 Full-Brim Helmet $59 Helmet Outerwear Level OK Cost OK 58 Firefighting Goggles $49 Helmet Safety Equipment Level OK Cost OK 31 Water Throw Bag $59 Safety Water Rescue Level OK Cost OK 32 Dry Bag $18 Safety Water Rescue Level OK Cost OK

Edited by: Your Name

11/1/2012 12:23

Lastname_Firstname_e04_Fire_Equipment.xlsx Equipment

Page 2 of 7 e04_Fire_Equipment_ann_solution.pdf

 

 

Date Quantity

Purchased Cost Each

Total Monthly

Cost January 1, 2010 20 $16.00 $320.00 February 1, 2010 20 $15.50 $310.00 March 1, 2010 10 $16.00 $160.00 April 1, 2010 20 $15.25 $305.00 May 1, 2010 15 $16.00 $240.00 June 1, 2010 15 $16.25 $243.75 July 1, 2010 10 $16.25 $162.50 August 1, 2010 10 $16.50 $165.00 September 1, 2010 10 $17.00 $170.00 October 1, 2010 20 $16.25 $325.00 November 1, 2010 10 $17.00 $170.00 December 1, 2010 10 $17.50 $175.00 Total $2,746.25 Average Cost $228.85 Minimum Cost $160.00 Maximum Cost $325.00

Cost Trend

Aspen Falls

Cost of Mesh Vests

Lastname_Firstname_e04_Fire_Equipment.xlsx Vest

Page 3 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Text Box
Insert SUM and AVERAGE functions
Skills for Success
Line
Skills for Success
Text Box
Create Sparkline in B22
Skills for Success
Line
Skills for Success
Line
Skills for Success
Text Box
Insert MAX and MIN functions

 

Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in Supply Item Type Category Supply Level Total

Cost 25 Proximity Coat Coat Outerwear Level OK $32,475 19 Fire Coat Coat Outerwear Level OK $18,791 17 Proximity Pants Pants Outerwear Level OK $18,003 35 EMS Jacket Coat Outerwear Level OK $13,965 47 EMS Pants Pants Outerwear Level OK $13,583 18 Fire Pants Pants Outerwear Level OK $11,682 37 Flare Beacon Kit Light Traffic Level OK $11,285 51 Structural Fire Helmet Helmet Outerwear Level OK $9,129 90 Flares with Stands Light Traffic Level OK $8,910

190 Radio Strap/Holder Radio Communication Level OK $8,548 25 Helmet with Eye Shield Shield Safety Equipment Level OK $8,475 21 Leather Fire Boots Boots Footwear Level OK $7,140 20 10″ Zipper Boots Boots Footwear Level OK $6,400 57 Disaster Kit Safety Safety Equipment Level OK $5,643 28 Safety Harness Safety Safety Equipment Level OK $5,572 13 Respirator Safety Safety Equipment Level OK $4,797 16 Handheld Remote Siren Siren Traffic Level OK $4,624 27 Rubber Fire Boots Boots Footwear Level OK $4,563

146 Coil Headphones Radio Communication Level OK $4,378.54 11 Extrication Coveralls Coveralls Extrication Gear Level OK $3,949 17 Extrication Coat Coat Extrication Gear Level OK $3,791 38 Water Rescue Vest Safety Water Rescue Level OK $3,762 28 Rubber Bunker Boots Boots Footwear Level OK $3,612 19 Siren Siren Traffic Level OK $3,591 27 Proximity Gear Gloves Gloves Outerwear Level OK $3,348 19 Coverall with Hood Coveralls Outerwear Level OK $3,021 29 Chest Harness Safety Safety Equipment Level OK $2,871 58 Firefighting Goggles Helmet Safety Equipment Level OK $2,842

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Sort by Cost

Page 4 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Line
Skills for Success
Text Box
Create worksheet copies

 

Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in Supply Item Cost Each Type Category Supply Level Check Supplier Total

Cost

9 Gas Mask $259 Safety Safety Equipment Order Cost OK $2,331 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK $315

57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK $5,643 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 13 Respirator $369 Safety Safety Equipment Level OK Check new supplier $4,797 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK $585 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385

Total $139 $22,499

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Supply Level

Page 5 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Text Box
Filter Excel table
Skills for Success
Line
Skills for Success
Text Box
Create Excel table and add Total row
Skills for Success
Line

 

Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in Supply Item Cost Each Type Category Supply Level Check Supplier Total

Cost

28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385

Total 3

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Harness

Page 6 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Line
Skills for Success
Text Box
Filter Excel table

 

Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in Supply Item Cost Each Type Category Supply Level Check Supplier Total

Cost

9 Gas Mask $259 Safety Safety Equipment Order Cost OK $2,331 9 Extrication Gloves $77 Gloves Extrication Gear Order Cost OK $693 8 Megaphone $79 Megaphone Communication Order Cost OK $632 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK $315 4 Water Tether System $59 Safety Water Rescue Order Cost OK $236 3 Retractable Mic Keeper $20 Radio Communication Order Cost OK $60

25 Proximity Coat $1,299 Coat Outerwear Level OK Check new supplier $32,475 19 Fire Coat $989 Coat Outerwear Level OK Check new supplier $18,791 17 Proximity Pants $1,059 Pants Outerwear Level OK Check new supplier $18,003 35 EMS Jacket $399 Coat Outerwear Level OK Check new supplier $13,965 47 EMS Pants $289 Pants Outerwear Level OK Cost OK $13,583 18 Fire Pants $649 Pants Outerwear Level OK Check new supplier $11,682 37 Flare Beacon Kit $305 Light Traffic Level OK Check new supplier $11,285 51 Structural Fire Helmet $179 Helmet Outerwear Level OK Cost OK $9,129 90 Flares with Stands $99 Light Traffic Level OK Cost OK $8,910

190 Radio Strap/Holder $45 Radio Communication Level OK Cost OK $8,548 25 Helmet with Eye Shield $339 Shield Safety Equipment Level OK Check new supplier $8,475 21 Leather Fire Boots $340 Boots Footwear Level OK Check new supplier $7,140 20 10″ Zipper Boots $320 Boots Footwear Level OK Check new supplier $6,400 57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK $5,643 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 13 Respirator $369 Safety Safety Equipment Level OK Check new supplier $4,797 16 Handheld Remote Siren $289 Siren Traffic Level OK Cost OK $4,624 27 Rubber Fire Boots $169 Boots Footwear Level OK Cost OK $4,563

146 Coil Headphones $30 Radio Communication Level OK Cost OK $4,378.54 11 Extrication Coveralls $359 Coveralls Extrication Gear Level OK Check new supplier $3,949 17 Extrication Coat $223 Coat Extrication Gear Level OK Cost OK $3,791 38 Water Rescue Vest $99 Safety Water Rescue Level OK Cost OK $3,762 28 Rubber Bunker Boots $129 Boots Footwear Level OK Cost OK $3,612 19 Siren $189 Siren Traffic Level OK Cost OK $3,591 27 Proximity Gear Gloves $124 Gloves Outerwear Level OK Cost OK $3,348 19 Coverall with Hood $159 Coveralls Outerwear Level OK Cost OK $3,021 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 58 Firefighting Goggles $49 Helmet Safety Equipment Level OK Cost OK $2,842 26 Rubber Lug Boot $109 Boots Footwear Level OK Cost OK $2,834 87 Rope Gloves $32 Gloves Outerwear Level OK Cost OK $2,784 14 Extrication Pants $189 Pants Extrication Gear Level OK Cost OK $2,646 89 Breakaway Vest $29 Vest Outerwear Level OK Cost OK $2,581 10 Helmet $229 Helmet Outerwear Level OK Cost OK $2,290 25 Fire Gloves $89 Gloves Outerwear Level OK Cost OK $2,225 17 Water Rescue Kit $119 Safety Water Rescue Level OK Cost OK $2,023 31 Water Throw Bag $59 Safety Water Rescue Level OK Cost OK $1,829 10 Hazmat Boot $149 Boots Footwear Level OK Cost OK $1,490 34 Rescue Glove Liners $39 Gloves Outerwear Level OK Cost OK $1,326 18 Wildfire Helmet $59 Helmet Outerwear Level OK Cost OK $1,062 41 Leather Radio Holder $25 Radio Communication Level OK Cost OK $1,025 17 Full-Brim Helmet $59 Helmet Outerwear Level OK Cost OK $1,003 89 Reflective Nylon Vest $11 Vest Outerwear Level OK Cost OK $979 10 Haz-Mat Boots $89 Boots Footwear Level OK Cost OK $890 56 Night Barrier Tape $15 Tape Traffic Level OK Cost OK $840 25 Mesh Traffic Vest $29 Vest Outerwear Level OK Cost OK $725 53 Barrier Tape $12 Tape Traffic Level OK Cost OK $636 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK $585 32 Dry Bag $18 Safety Water Rescue Level OK Cost OK $576 10 Chemical Overboot $52 Boots Footwear Level OK Cost OK $520 27 Traffic Baton $19 Baton Traffic Level OK Cost OK $513 26 Traffic Flashlight $18 Light Traffic Level OK Cost OK $468 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385 15 Mesh Vest $17 Vest Outerwear Level OK Cost OK $255

Total 59

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Inventory

Page 7 of 7 e04_Fire_Equipment_ann_solution.pdf

 

Skills for Success
Text Box
Convert Excel table to a range
Skills for Success
Line
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Java Programming

/in /by
  1. This lab continues the Zuul project.Make a copy of your Lab 1 Zuul project folder (e.g., the folder named LastName-zuul1) and save it as LastName-zuul, using your last name, e.g., Smith-zuul.
  2. Set up a Git repository for your Zuul project by following the instructions Set Up a Repository for a Project. (Start following along at 0:25 in the video since you already have an existing project.)
  3. In Git, create a branch called ‘zuul2-refactoring’ and move onto the branch. You will do all your work for this lab on this branch, committing after each exercise.git branch zuul2-refactoring git checkout zuul2-refactoring
  4. Complete Exercises 6e: 8.5, 8.6, 8.7, 8.8, 8.11 .
  5. After each exercise:
    1. Test your program. The changes you make in these exercises are refactorings and should not change the behavior of the game. After each step make sure everything still works as it did before.
    2. Don’t forget to document your changes.
      • For any changed classes, be sure your name is in the @author list and update the version.
      • As you add and update methods make sure each method has a comment header that correctly describes its behavior using javadoc, including @param and @return tags.
    3. When an exercise is complete, commit your changes in Git with a commit message indicating the exercise you just completed as well as a brief description of the changes you made. For example:git add . git commit -m”Completed exercise 8.5 – extracted method printLocationInfo”
      It is critical that you commit after each exercise so that all exercises can be graded. Later exercises change the code from earlier exercises, and the instructor will be able to grade the early exercises by looking back in your commit history.
  6. When you have completed all the exercises, make sure your branch is clean. (When you do ‘git status’ it should say “On branch zuul2-refactoring. nothing to commit, working tree clean”)
  7. Merge your branch into the master:git checkout master git merge zuul2-refactoring
  8. Create a zip file of your entire project folder, and name it LastName-zuul2.zip
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Excel Basic Project 17 Steps

/in /by

Office 2013 – myitlab:grader – Instructions Exploring – Excel Chapter 4: Homework Project 1

Mountain View Realty

 

Project Description: A coworker developed a spreadsheet listing houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and format the table.

 

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded file named exploring_e04_grader_h1.xlsx. 0 2 In the Sales Data worksheet, freeze the top row. Hint: On the VIEW tab, in the Window group, click Freeze Panes and then click Freeze Top Row. 5 3 In the Sales Data worksheet, convert the data to a table and apply Table Style Medium 17. Hint: To convert the data, on the INSERT tab, in the Tables group, click Table. To apply the style, on the DESIGN tab, in the Table Styles group, click the More button. 6 4 In the Sales Data worksheet, remove duplicate records in the table. Hint: On the DESIGN tab, in the Tools group, click Remove Duplicates. 5 5 In the Sales Data worksheet, insert a new field to the right of the Selling Price field. Name the new field Percent of List Price. Hint: Right-click the Column E header and click Insert. 6 6 In the Sales Data worksheet, create a formula in cell E2 with structured references to calculate what percent the selling price is of the list price. Format the field with Percent Style with one decimal place in the range E2:E43. Hint: In cell E2, enter the formula =[Selling Price]/[List Price]. To format the range, on the HOME tab, in the Number group, click the Number Format Dialog Box Launcher. 6 7 In the Sales Data worksheet, insert a new field to the right of the Sale Date field. Name the new field Days on Market. Create a formula with structured references to calculate the number of days on the market. Hint: In cell H1, type Days on Market and press ENTER. To insert the formula, in cell H2, type =[Sale Date]-[Listing Date]. 6 8 In the Sales Data worksheet, add a total row to display the average percent of list price and average number of days on market. Apply the General number format to the average number of days on market. Type Averages in cell A44. Hint: To display the Total row, on the DESIGN tab, in the Table Style Options group, click Total Row. To select the function, click the cell, click the arrow, and then click the function. 10 9 In the Sales Data worksheet, sort the table by City in alphabetical order and add a second level to sort by Days on Market with the houses on the market the longest at the top within each city. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 8 10 In the Sales Data worksheet, select the Listing Date and Sale Date fields and set a column width of 11.00. Wrap the column labels in the range E1:H1. Hint: To set the column width, on the HOME tab, in the Cells group, click Format. To wrap the labels, in the Alignment group, click Wrap Text. 6 11 Set up the Sales Data worksheet so that when printed, the first row containing the field names will print as titles on each page. Hint: On the PAGE LAYOUT tab, in the Page Setup group, click Print Titles. 5 12 Display the Sales Data worksheet in Page Break Preview and move the page break to occur between rows 26 and 27, and then change back to Normal view. Hint: To display Page Break Preview, on the VIEW tab, in the Workbook Views group, click Page Break Preview. To insert the page break, click cell A27 and on the PAGE LAYOUT tab, in the Page Setup group, click Breaks. 5 13 Display the Filtered Data worksheet. Convert the table to a range of data. Hint: On the DESIGN tab, in the Tools group, click Convert to Range. 5 14 Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 6 15 Use a custom AutoFilter to display records for houses that were on the market 30 days or more. 5 16 Apply the 3 Arrows (Colored) icon set to the days on market field values. Do not include the field name in the range. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Icon Sets. 5 17 Apply the Light Blue Data Bar conditional formatting in the Gradient Fill section to the selling prices. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Data Bars. 5 18 Create a new conditional format that applies Yellow fill (fourth color in the bottom row) and bold font to values that are higher than 98% for the Percent of List Price column. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then click New Rule. 6 19 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Sales Data, Filtered Data. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100

 

Updated: 04/04/2013 1 E_CH04_EXPV1_H1_Instructions.docx

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

For Prof. Gegee!!!

/in /by

WEEK 1

 

In order to complete the labs, you must install WAMP, the development server, and a PHP editor of choice, on your Windows computer.

A.                Install the WAMP Development Server following steps in Appendix B.

Install the PHP Editor Tools following steps in Appendix A

For the power users that want to step up from editing using Notepad, install one of these preferential PHP code editor:
⧫    Microsoft Windows WordPad Editor (an optional improvement)

⧫    Microsoft Web Expressions 4.0 (the recommended improvement)

⧫    Microsoft Visual Studio Editor (an optional improvement) Complete Lab Work:

 

o   Discovery Project 1-1 (p.72)

o   Discovery Project 1-2 (p.72)

o   Discovery Project 1-3 (p.73)

o   Discovery Project 1-4 (p.73)

 

WEEK 2

 

●  Save any coded PHP programs and scripts in the directory C:\wamp64\www\Wk2Exercise where you will ZIP and Submit the weeks PHP scripts and programs.

●  Submit the completed Exercises (Zip file of Wk2Excercise) directory to the dropbox under the Week1: Assignment submission area as an attachment.

Reinforcement Exercises

o   Exercise 4-1 (pages 221-224)

o   Exercise 4-2 (pages 224-227)

o   Exercise 4-3 (page 228)

o   Exercise 4-4 (page 228)

o   Exercise 4-5 (page 228)

 

o   Exercise 5-1 (pages 288-289)

o   Exercise 5-2 (pages 289-291)

o   Exercise 5-3 (page 291)

o   Exercise 5-4 (page 291)

o   Exercise 5-5 (pages 291-292)
o   Exercise 6-1 (pages 369-373)

o   Exercise 6-2 (page 373)

o   Exercise 6-3 (pages 373-376)

o   Exercise 6-4 (page 376

o   Exercise 6-5 (page 376)

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

4 Case Studies Due Date Today 8pm

/in /by

1.You have just been hired to perform digital investigations and forensics analysis for a company. You find that no policies, processes, or procedures are currently in place. Conduct research to find information, and then create a policy and process document (3 to 4 pages in length) to provide the structure necessary for your lab environment. Be sure to cite your online sources and follow APA formatting.(3,4)

2.Establish a procedure for your organization on how to validate a new forensics software package. Write 3 to 4 pages outlining the procedure you plan to use in your lab. Be sure to cite references, such as the ISO standard or NIST, to support your procedure. Make sure you use APA formatting.(chapter 5,6)

3.As part of the duties of a digital forensics examiner, creating an investigation plan is a standard practice. Write a 3 to 4 (not including title or reference page) page paper that describes how you would organize an investigation for a potential fraud case. In addition, list methods you plan to use to validate the data collected from drives and files such as Word and Excel, with hashes. Specify the hash algorithm you plan to use, such as MD5 or SHA1. Make sure you follow the grading rubric and write your paper in APA format.(chapter 9,10)

4. A mother calls you to report that her 15-year-old daughter has run away from home. She has access to her daughter’s e-mail account and says her daughter has a number of emails in her inbox suggesting she has run away to be with a 35-year-old woman. Write a 2 to 3 page paper/report (not including title or reference page) explaining how you should proceed. Make sure you adhere to the grading rubric and write the report in APA format.(chapter 11,12)

· 3-4 pages in length  (excluding cover page, abstract, and reference list)

· APA format, Use the APA template located in the Student Resource Center to complete the assignment.

· Please use the Case Study Guide as a reference point for writing your case study.

Refere text book :

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Raptor Programming

/in /by

Below I have listed the second assignment for you to do.  Every assignment should be submitted with a cover page.  With that being said please do the following assignments.

** To complete this assignment Chapter0 – Chapter3 should be reviewed.  Also see the document “Introduction to Raptor Tutorials” for assistance using Raptor.

2nd Assignment is located in the AITT-Summer 2018\Assignments folder.  Please answer all questions and submit. The questions can be answered within the document.

1)  AITT4300 – Assignment2

The second part of the assignment is also located in the AITT-Summer 2018\Assignment folder.  The document isAITT4300_Chapter3_PC_1-5.

2)  Under the section Programming Challenges (page 177), do questions 4 and 5.  This assignment should be done in a project format.  The two problems are to be submitted as one project.

I. Cover Page

II. Background/Theory

III. Problem Statement

IV. Pseudocode

V. Flowchart

VI. Code

VII. Results

VIII. Conclusion

 

Below I have listed the first assignment for you to do.  Every assignment should be submitted with a cover page.  With that being said please do the following assignments.

** To complete this assignment Chapter0 – Chapter3 should be reviewed.  Also see the document “Introduction to Raptor Tutorials” for assistance using Raptor.

1st Assignment is located in the AITT-Summer 2018\Assignments folder.  Please answer all questions and submit. The questions can be answered within the document.

1)  Try_It_Yourself_AppendixA_Exercises

2)  Try_It_Yourself_AppendixB_Exercises

2nd Assignment is also located in the AITT-Summer 2018\Assignment folder.  The document is Chapter3_Questions.pdf.

1) Under the section Programming Problems (page 161), do questions 1 and 2.  This assignment should be done in a project format.  The two problems are to be submitted as one project.

I. Cover Page
II. Background/Theory
III. Problem Statement
IV. Pseudocode
V. Flowchart
VI. Code
VII. Results
VIII. Conclusion

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Challenge Yourself 3.3

/in /by

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

1 | Page Challenge Yourself 3.3 Last Updated 3/19/18

Challenge Yourself 3.3 In this project you will complete a vehicle shopping workbook to compare the purchase of several vehicles. After completing the project, you can make a copy of the file and use it to compare vehicle purchases you are considering for yourself. Be sure to save your work often!

Skills needed to complete this project: • Naming Ranges of Cells

• Calculating Averages

• Finding Data Using the VLOOKUP Function

• Working with Named Ranges

• Using the Function Arguments Dialog to Enter Functions

• Using the Logical Function IF

• Calculating Loan Payments Using the PMT Function

• Creating Formulas Referencing Data from Other Worksheets

• Displaying and Printing Formulas

• Finding Errors Using Trace Precedents and Trace Dependents

• Finding Minimum and Maximum Values

• Using Formula AutoComplete to Enter Functions

• Updating Named Ranges with the Name Manager

• Editing and Deleting Names with the Name Manager

• Checking Formulas for Errors

1. Open the start file EX2016-ChallengeYourself-3-3. The file will be renamed automatically to include your

name. Change the project file name if directed to do so by your instructor, and save it.

2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the

top of the workbook so you can modify it.

3. The registration fee information in cells B11:C17 on the Data sheet will be used in lookup formulas later in

this project. Name the range RegistrationFees to make it easier to use later.

4. Return to the Purchase worksheet.

5. Calculate the average MPG for each vehicle.

a. Enter a formula in cell C10 using the AVERAGE function to calculate the average value of C8:C9.

Use only one argument.

b. Copy the formula to the appropriate cells for the other vehicles.

c. Excel will detect a possible error with these formulas. Use the SmartTag to ignore the error. Hint: Use

the SmartTag while cells C10:F10 are selected and the error will be ignored for all the selected cells.

6. Calculate the registration fee for each vehicle.

a. Enter a formula in cell C13 to look up the registration fee for the first vehicle. Use the vehicle type in

cell C4 as the Lookup_value argument. Use the RegistrationFees named range as the Table_array

argument. The registration fees are located in column 2 of the data table. Require an exact match.

b. Copy the formula to the appropriate cells for the other vehicles.

Step 1

Download start file

 

 

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

2 | Page Challenge Yourself 3.3 Last Updated 3/19/18

7. Determine whether or not you will need a loan for each potential purchase.

a. In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is

located on the Data sheet in cell A3. If the price of the car is less than or equal to your available cash,

display “no”. If the price of the car is more than your available, cash, display “yes”. Use absolute

references where appropriate—you will be copying this formula across the row.

b. Copy the formula to the appropriate cells for the other vehicles.

8. Calculate how much you would need to borrow for each purchase.

a. In cell C16, enter a formula to calculate the price of the vehicle minus your available cash (from cell A3

in the Data worksheet). Use absolute references where appropriate—you will be copying this formula

across the row.

b. Copy the formula to the appropriate cells for the other vehicles.

9. Calculate the monthly payment amount for each loan.

a. In cell C20, enter a formula using the PMT function to calculate the monthly loan payment for the

first vehicle.

• Hint: Divide the interest rate by 12 in the Rate argument to reflect monthly payments.

• Hint: Multiply the number of years by 12 in the Nper argument to reflect the number of monthly

payments during the life of the loan.

• Hint: Use a negative value for the loan amount in the Pv argument so the payment amount is expressed

as a positive number.

b. Copy the formula to the appropriate cells for the other vehicles.

10. Compute the monthly cost of gas.

a. In cell C21, enter a formula to calculate the number of miles you expect to drive each month. Divide

the value of number of miles (cell A5 from the Data sheet) by the average MPG for the vehicle

multiplied by the price of a gallon of gas (cell A6 from the Data sheet).

b. Copy the formula to the appropriate cells for the other vehicles.

c. If cells D21:F21 display an error or a value of 0, display formulas and check for errors.

d. If you still can’t find the error, try displaying the precedent arrows.

e. Hint: The references to the cells on the Data sheet should use absolute references. If they do not, the

formula will update incorrectly when you copy it across the row.

11. Compute the monthly cost of maintenance.

a. In cell C22, enter a formula to calculate the monthly maintenance cost: Divide cell C12 by 12.

b. Copy the formula to the appropriate cells for the other vehicles.

12. Compute the monthly cost of insurance.

a. In cell C23, enter a formula to calculate the monthly insurance cost: Divide cell C14 by12.

b. Copy the formula to the appropriate cells for the other vehicles.

 

 

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

3 | Page Challenge Yourself 3.3 Last Updated 3/19/18

13. In cells C24:F24, compute the total the monthly cost for each vehicle.

14. Determine which vehicles are affordable.

a. In cell C26, enter a formula using the IF function to display “yes” if the total monthly cost (cell C24)

is less than or equal to the total monthly amount available for vehicle expenses (Data sheet, cell A4).

Display “no” if the total monthly cost is not less than or equal to the total monthly amount available.

b. Copy the formula to the appropriate cells for the other vehicles.

c. Display formulas and use the error checking skills learned in this lesson to track down and fix

any errors.

15. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell

references in the formulas. Calculate the average, highest, and lowest values for each of the following:

a. Price

b. MPG City

c. MPG Highway

d. Average MPG

e. Maintenance/Year

f. Registration Fee

g. Insurance/Year

h. Amount to Borrow

i. APR

j. Years

k. Loan Payment

l. Gas

m. Maintenance/Month

n. Insurance/Month

o. Total Monthly

Hints:

• Select cells B7:F24 and use Excel’s Create from Selection command to create named ranges for each

row using the labels at the left side of the range as the names.

• Open the Name Manager and review the names Excel created. Notice that any spaces or special

characters in the label names are converted to _ characters in the names.

• To avoid typos as you create each formula, try using Formula AutoComplete to select the correct

range name.

16. Before finishing the project, check the worksheet for errors.

17. Save and close the workbook.

18. Upload and save your project file.

19. Submit project for grading.

Step 2

Upload & Save

Step 3 Grade my Project

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

CIS 110 LAB ASSIGNMENT DETAILS AT THE ATTACHED…

/in /by

Week 1 Lab Assignment 1: Install Visual Logic

Click the link above to submit your assignment.

Complete lab 1 using Visual Logic in which you:

1. Submit a word document with a screenshot showing successful installation of Visual Logic.

1. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:

. A summary of the technical experiences that you used in completing this lab.

. The commands that were of greatest benefit to you.

. Your general comments on the overall lab experience.

 

 

Week 2 Lab Assignment 2 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.

2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:

1. A summary of the technical experiences that you used in completing this lab.

2. The commands that were of greatest benefit to you.

3. Your general comments on the overall lab experience.

 

 

Week 4 Lab Assignment 3 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.

2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:

1. A summary of the technical experiences that you used in completing this lab.

2. The commands that were of greatest benefit to you.

3. Your general comments on the overall lab experience.

 

Week 7 Lab Assignment 4 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.

2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:

1. A summary of the technical experiences that you used in completing this lab.

2. The commands that were of greatest benefit to you.

3. Your general comments on the overall lab experience.

 

 

 

Week 8 Lab Assignment 5 Submission

Click the link above to submit your assignment.

 

Complete labs 2-5 using Visual Logic in which you:

1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.

2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:

1. A summary of the technical experiences that you used in completing this lab.

2. The commands that were of greatest benefit to you.

3. Your general comments on the overall lab experience.

 

 

 

Lab Assignment Breakdown

Week Due

Graded Lab Exercises

Points

1

Lab 1: Visual Logic Installation

10

2

Lab 2: Exercise 6 on page 35

10

4

Lab 3: Exercise 5 (Part A) on page 172

20

7

Lab 4: Chapter 9 Exercise 4 on page 421

 

Lab 5: Exercise 4 on page 468

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Data Science And Methodology Assignment (Small Assignment – I Need In 6 Hours)

/in /by

See assignment details below. Please make sure answers are correct as per this link https://tdwi.org/~/media/64511A895D86457E964174EDC5C4C7B1.PDF  NO REFERENCES REQUIRED. NO MIN WORD COUNT. I have attached the below as a PDF

 

In this Assignment, you will demonstrate your understanding of the   data science methodology by applying it to a given problem. Pick one of the   following topics to apply the data science methodology to:

1. Emails

2. Hospitals

3. Credit Cards

You will have to play the role of the client as well as the data   scientist to come up with a problem that is more specific but related to   these topics.

__________________________________

Which topic did you choose to apply the data science methodology to? (2 marks)

……………………….

Next, you will play the role of the client and the data scientist.

Using the topic that you selected, complete the Business Understanding stage by coming up with a problem that you would like to solve and phrasing it in the form of a question that you will use data to answer. (3 marks)

You are required to:

1. Describe the problem, related to the topic you selected.

2. Phrase the problem as a question to be answered using data.

For example, using the food recipes use case discussed in the labs, the question that we defined was, “Can we automatically determine the cuisine of a given dish based on its ingredients?”.

…………………………

Briefly explain how you would complete each of the following stages for the problem that you described in the Business Understanding stage, so that you are ultimately able to answer the question that you came up with. (5 marks):

1. Analytic Approach

2. Data Requirements

3. Data Collection

4. Data Understanding and Preparation

5. Modeling and Evaluation

You can always refer to the labs as a reference with describing how you would complete each stage for your problem.

………………………………

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Sony BUSINESS PROBLEMS AND DECISION MAKING

/in /by
 
Sony
BUSINESS PROBLEMS AND DECISION MAKING
 
 
12/6/2015

 

 

In this paper we will discuss in detail about the analysis and problem solving approach of Sony.

Umer Arif

MIS 535

Prof. Najib Kalai

 

 

TABLE OF CONTENTS

ABSTRACT   ………………………………………………            3

INTRODUCTION     ………………………………………            4

COMPANY BACKGROUND         ………………………            5

PROBLEMS FACED BY SONY     ……………………….            6-7

PROBLEM SOLVING PROCESS   ………………………            8-10

APPROACHES USED BY SONY   ………………………            10

TOOLS USED BY SONY    ………………………………            11

SOLUTIONS TAKEN BY SONY    ………………………            12-13

SWOT ANALYSIS OF PDCA         ………………………            14

CONCLUSION         ……………………………………….           15

REFERENCES          ……………………………………….           16

 

ABSTRACT

Decision making and problem solving are important skills for any business. Sony is a leading company in innovation but they gradually lost their superiority in the new competitive world of innovation and the presence of new technology to solve business problems.

In this report, we discuss the current procedures adopted to analyze and solve the problem and also the tools used by Sony to get these problems solved. We also identify the best solutions and new opportunities which helps Sony to become a leader again.

In this report, I would like to perform SWOT (Strength, Weakness, Opportunities and Threats) analysis on the existing model (Plan-Do-Check-Act Cycle- PDCA Cycle) of Sony. I will compare the existing model with other available models in the market and suggest the recommendations to the company by findings and comparative results.

Finally, I will implement the best strategy adopted by Sony to solve their problems in the future.

 

 

INTRODUCTION

 

Sony lost its magic formula from last decades. Company lost it high position in the market. By seeing continuous downfall in the sales of Sony, the management finds the solution to this problem and plans to reorganize the company “ONE SONY” to prioritize the business. But this solution didn’t help the company at all. The downfall in the sales continues and Sony lost its position in the World market day by day.

From last several months, Sony is facing an expected loss of $640 million in financial year 2011 (Jeff Blagdon, 2012) due to increase in tax charges and restructuring costs. Sony also incurs a loss of $312 million in Q1 of financial year 2012 (Daniel Copper, 2012). Sony is continuously losing money and its position in the market and don’t have any chance for its growth in recent years due to its problem solving strategies.

A reputed business magazine reports that the shares of Sony is at its lowest price in 31 years of period and incur a net loss of 456.7bn yen at the end of March, 2012 (NEWS Business, 2012). Sony’s movies, music and financial proves to be profitable in the quarter but regular loss from television, personal computers and mobile phones bring the company to its bottom line.

 

SONY COMPANY PROFILE

Sony is a Japanese multinational corporation established in 1946 and headquarter is located in Tokyo, Japan. Sony is the leading manufacturer in the field of consumer electronics such as refrigerator, television, mobile phones etc. In the list of Fortune Global 500, its rank was 87th in 2012 (CNN Money, 2012). Sony is an international company which is engaged in the development, design, manufacture and sale if various consumer electronic products (The New York Times, 2012). Sony also contact third party manufactures for information technology products. Sony’s sales team and management work hard to sales its products globally through subsidiaries, retailers, distributors and office websites. Sony is also engaged in entertainment industry including Pictures, Music. Sony is also engaged in financial services such as banking and credit financing. Sony is also engaged in network services and advertisement business.

 

PROBLEMS FACED BY SONY

Sony is facing many problems but there are two main reasons which lead to the decline in Sony. These reasons are:

Lack of Innovation

The major quality of Sony is its development of innovation. Sony has the ability to develop new products according to the consumers need. They understand the hidden needs of the consumer well and try to develop new innovative products to fulfill their needs. The development of Walkman made him leader in the field of portable music players but they didn’t continue with this product and never upgrade it to sustain its initial success (Surowiecki’s, 2011). When Apple iPad is launched in the market, they prove to be a big challenge for the innovative ideas of Sony (Business@GW, 2012). Sony is continuously losing its consumer oriented innovative ideas which directly harms the reputation of Sony (Hirai, 2012).

Lack of Core Competence

Another reason behind Sony’s fall is that Sony ignored the improvement in its core business of developing innovative ideas. They stuck into their new multiple businesses of financial services, music label, online music store, advertisement agency, movies and games. Sony is lacking behind in product positioning and branding due to lack of focuses and core competence (Byford, 2012).

Objectives

Sony identifies these two problems as the vital business problems. Once Sony lacks in innovation, it also lose core competency. With the help of problem solving and decision making skills, we can identify the root cause of the problems and find best solutions to overcome from these problems. The best solutions and theory helps Sony to gain competitive advantage over their rivals.

With the help of problems which we have studied for Sony, we will discuss how to solve critical business problems by adopting proper strategies and how to implement these overall strategies to achieve the goal. This problem solving process include theories, analysis of situations with the help of real life management problems, help us in understanding decision making skills and strategies and finally teach us how to solve real life problems in future.

Overview of the Problem Solving and Decision Making

Problem Solving and decision making are important skills for any organization to survive in today’s competitive world (Shibata, 1997). Problem Solving is a methodology in which we proceed step by step to analyze a situation and then develop and implement available solutions of the problem (Kendra, 1997). Decision making is nothing but taking right decision at every step of problem solving process (Adair, 2010). The quality of decision making supports problem solving process in order to get better results for business strategies (Greg, 2009).

  

PROBLEM SOLVING PROCESS IN SONY

Consumers need and requirements are changing everyday as electronic market is developing and reach to its new heights. Sony has to take immediate steps to reinforce its competitive advantages (Mariko, 2012). The major issue which should be resolved by Sony is to make their products more appealing to current consumers (Shunichi, 2012). With reference to business, problem solving approach begins with the analysis of problem and ends with the solution with the help of which organization gains profit (Ozasa, 2000).

Sony use a five step integrated problem solving and decision making process (Saeromi, 2012). Sony deals with this process of problem solving and decision making together to achieve the best solutions for the business problems in order to get effective and quick solutions (Yau, 2011). The table below describes all the five steps in brief and then we will discuss all the steps in detail and how Sony applies them to the problems.

 

 

Table 1: Problem Solving Process in Sony

STEP PROBLEM SOLVING STAGE DECISION MAKING
1 Identify the problem 1 Frame the decision.
2 Explore alternatives 2 Innovate to address needs and identify alternatives.
3 Select an alternative 3 Decide and commit to act.
4 Implement the solution 4 Manage consequences.
5 Evaluate the solution 4 & 1 Manage consequences and frame the related decision.

 

Step 1: Begin with a Problem and treat it as a challenge

All business has problems. Problem solving process starts with the analyses of problem and then to treat these problems as a challenge. The major problem of Sony is in the reduction of sales of products. For this, Sony is trying to collect all the information related to its products, services and market. Once the major problems are identified, Sony will consider these problems into the challenges.

Step 2: Explore Alternatives

The second step is to explore alternative solutions to the problem identified in Step 1. In this step we generate alternative solutions and then evaluate the alternatives. After Sony will generate all the alternatives for the problem then they will make criteria to prioritize the solutions. To generate alternative solutions Sony may adopt some approaches like group discussions and market surveys.

Step 3: Select an alternative

In this step, we have to select the best solution to implement. After evaluating all the alternatives, the best solution which is closest to the problem will be evaluated properly. Sony will have to make proper check to identify all the results by implementing the solution. This step is a critical step in problem solving process as one wrong decision may lead to entire failure of system.

Step 4: Implement the solution

Sony is now ready to implement the plan entirely. In this Sony will have to implement the solutions with five parts: develop a basic plan, determine objectives, identify the resources required, and build a plan and finally implement the plan.

Step 5: Evaluate the situation

The last but the major step is evaluating all the situations after implementing the process. In this we have to monitor the ongoing process with the decision making process to achieve the goal of organization.

APPROACHES USED BY SONY

CPS approach is used by Sony to adopt changes made inside the organization. Sony recognizes that its own employees have innovative ideas but the only need is to put these ideas at right place and also have to motivate them to share those ideas. In this approach, Sony develops a team of personnel to participate in the change process and share their ideas. This process brings all employees, employers and even consumers. Sony use CPS approach to encourage consumers to participate in the survey which helps in innovating new ideas rather than to rely on traditional ideas of problem solving.

The major characteristic of this approach is that it converts the problems into opportunities and help Sony in the development of their business. With the help of this approach Sony not only able to generate new innovative ideas but also gain competitive advantage over its competitors. It helps Sony to re-define the problems they are facing, change these problems into challenges with new innovative ideas and then take appropriate actions to achieve the goals.

Sony consider CPS approach as an innovator and try to resolve each and every problem to gain competitive advantage with new innovative ideas and develop new and latest products by keeping the consumer needs in mind and become a leader in its market again.

 

 

 

TOOLS USED BY SONY

PDCA Cycle (Plan-Do-Check-Act) is a four step never ending tool used by Sony for continuous improvement (Walter Shewhart, 1986). This cycle is just like a circle which is repeated again and again for continuous improvement. PDCA tool helps Sony to control and continuous improvement of products and market (Golum, 2010). PDCA cycle helps Sony to answer some major questions in problem solving and decision making process. The table below explains it.

Table 2: Objective of PDCA cycle at each stage by Sony

PLAN  
Identify the problems – what Analyze the problem and identify the future business opportunities of Sony. Set SMART (Specific, Measureable, Agreed, Realistic and Timeframe) Goals.
Analyze the problems – why Analyze the root cause of the problem so that we get best solution for the problem. We have to gather data from the personnel in this step.
Develop solutions Find more than one potential solution for the problem and also make plan to chose and implement the best solution from all the alternatives.
DO  
Implement Solutions Sony will immediately and cost effectively implements the best solution to solve the problem and collect and record the results for further improvement.
CHECK  
Evaluate and study results Sony will check all the desired results of the new solution and if Sony will found any undesirability in the solution, they will return to plan phase to find another best solution by analyzing the problem again.
ACT  
Implement the full scale solutions Sony will now fully implement the new solution with all the changes necessary to adopt this solution, provide proper training and also look for future opportunities.

 

 

SOLUTION TAKEN BY SONY AND ALTERNATIVES

Innovation Oriented Solution

Innovating new ideas and technology was the key of success for Sony which is lost from several years. In order to reinforce its capabilities in the field of innovation, Shoji Nemoto (head of innovation technology) and Tomoyuki Suzuki (image senior Vice President) take a serious lead towards it and guide individuals of Sony to develop new technologies and ideas with their great experience in the field of R&D and technical knowledge (Ellen, 2012). Sony also lead by Kunimasa Suzuki (head of products and services innovation strategy) to provide efficient technological ideas for the existing product line (Rosen, 2012). Sony is now working in order to generate new innovative ideas and also acquire next generation innovative technology. The important departments like R&D, design and marketing consumer centric to develop new ideas and technologies which helps the company to re design all the products and regain the image of the products.

Sony is now working with long term strategies and growing ever faster in the field of developing new ideas and technologies. They are now capable of developing true values to its products so that the products will be closer to the consumers and will be liked by them. The major success and growing field of Sony is its new developing business in the field of medical. They start developing printers, monitors, cameras and other useful equipments in the field of medical. Till yet its medical business line is not a separate unit but scattered at various business lines but now they decide to make a different and separate medical business group under the leadership of Executive Deputy President Hiroshi Yoshioko (Sony Annual Report, 2012).

Brand Focus and Core Competence Oriented Solutions

After studying the need of the market and consumers, Sony wants to focus on three major areas of developing digital imaging, game and mobile business. They now adopt new technologies and features to make proper research for these products and wants to make investment in these areas to move forward. Sony decided to dedicate about 70% of its total R&D budget to these three areas only (Sony Group, 2012). Sony wants to regain its brand leadership by strengthening its brand focus.

Sony is also focusing in television business for which they are reducing their operational cost. They already make cost reduction in the manufacturing of LCD panel by reducing models in the year 2012 as compared to the year 2011. Sony also wants to make reduction in fixed business costs to up to 60% and also 30% reduction in operating costs (Sony Annual Report, 2012).

The alternative solution is the restructuring of organizational structure and operational units and also has to take necessary steps about the business units which are of no use to gain efficiency and enhancement in managerial and operational efficiency (Minato-ku, 2012).

Impact of these solutions

After implementing these solutions, the business from consumer electronics rises about 70% of overall sales and 80% of operating income came from this business unit at the end of year 2014 (Sony Annual Report, 2012). Sony also target total sales of digital imaging business unit of about 1.5 trillion yen and a double digit. Sony also focuses on game business and mobile business and target sales of one trillion yen and 1.8 trillion yen respectively with a profitability of 8%.

 

 

 

 

SWOT ANALYSIS OF PDCA CYCLE USED BY SONY

Strengths

·         With the help of this approach, Sony was able to identify the problem clearly with all the possible risks, able to find best solutions and then implement the solutions for the evaluation of business changes.

·         PDCA cycle is an effective tool with the help of which Sony will able to use its resources optimally and get best results.

·         Possibility of errors is reduced to its minimal after the completion of whole PDCA cycle.

·         Sony will able to take corrective measures and can change the solution if the solution chosen by them not suited the organization fully.

·         This will also save time of Sony while solving any problem in future also.
Weakness

·         PDCA cycle is a simple method which does not reflect some activities such as leadership, training and communication and other major skills.

·         PDCA cycle works only for short term strategies and improvements instead working for long term strategies and improvements.

·         Change is implemented in the organization, individual have no right to complain for it and resist it.
Opportunities

·         The “plan” step help Sony to think and make plans for future whereas “check” step helps Sony to identify whether the solution is able to achieve the goals or not.

·         PDCA cycle is a never ending process which continuously finds errors and corrects them at early stages only.

·         PDCA cycle help Sony to optimum utilization of its resources which make problem solving and decision making process simple and faster.

·         PDCA cycle is a continuous process which helps Sony to reduce the chance of mistakes.
Threats

·         Ignores the individual in an organization.

·         A major threat of PDCA cycle is its reactive nature which is far behind from the proactive approach of new methodologies and technologies.

·         PDCA cycle is a continuous improvement process and requires continuous changes which lead Sony in a continuous state of instability.

·         PDCA cycle may lead to uncertain environment which also lead to confusing and fatigue environment among the individuals.

 

CONCLUSION

Problem solving and decision making skills are important for the success of any individual or organization. The proper implementation of solution is required to make it a success. It is not an easy task but proper use of available technologies, methodologies, models and tools to support this process will lead to produce effective solutions. Effective problem solving and decision making approach requires careful identification, analysis, evaluation and step-by-step planning. It proved to be advantage if implemented in an effective manner and also a disadvantage for the business.

 

REFERENCES

Hirai (2012) Sony Accelerates Transformation to Drive Innovation and Growth. Available at: http://www.sony.net/SonyInfo/News/Press/200911/09-133E/index.html (January 24, 2013).

 

Kendra (1997). One Greater Lesson From Steve Jobs: Innovation Begins as A Social Movement. Available at: http://www.fastcodesign.com/1665211/steve-jobsembodied-the-entrepreneurial-capitalism-we-alllove (February 13, 2013).

 

Mariko (2012). An Overview of the General Theory of Innovation. Available at: http://www.trizjournal.com/archives/2008/04/06/ (February 15, 2013).

 

Minato-Ku (2012). Classic Brand Failures: Sony Betamax. Available at: http://brandfailures.blogspot.sg/2006/10/calssic-brand-failures-sony-betamax.html (February 15, 2013).

 

NEWS Business (2012). Sony Shares Tumble to 31-Year Low Amid Record Losses. Available at: http://www.bbc.co.uk/news/business-18030939 (February 20, 2013).

 

Ozasa (2000). Mapping the Problem Solving Process.Available at: http://www.studygs.net/problem/problemsolvingo. htm (February 20, 2013).

 

Problem Solving Process in Sony (2012).Available at: http://www.sony.net/SonyInfo/News/Press/index.html (February 20, 2013).

 

Rosen (2012). Creative Problem Solving Leads to Organizational Innovation. Available at:

http://www.projectsmart.co.uk/creative-problemsolving-leads-to-organisational-innovation.html

(February 21, 2013).

 

Shewhart, W. (1986). Innovation Process. Available at:http://www.jpb.com/creative/innovationprocess.php (March 4, 2013).

 

Shibata, H. (1997) Sony Says Professional Products to Help Consumer Unit. Available at:

http://www.bloomberg.com/news/2012-04-05/sonysays-professional- products-to-help-consumerunit.html (January 24, 2013).

 

Shunichi (2012). Overview of the Problem Definition Process. Available at: http://www.processinnovation.ca/problem/problemsolve.html (February 21, 2013).

 

Sony Annual Report (2012). Available at: http://www.sony.net/SonyInfo/IR/financial/ar/2012/

index.html (February 22, 2013).

 

Sony Group (2012). Decision-Making-Solution. Available at: http://www.decision-making-solutions.com/decision_making_model.html (February 22, 2013).

 

Surowiecki’s, J. (2011). Sony R & D Mission. Available at: http://www.sony.net/SonyInfo/technology/rd/index.html (February 7, 2013).

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!