代做COMM1110 Evidence-Based Problem Solving Assessment 3代写留学生Matlab语言

日期：2024-09-15 11:18

COMM1110 Evidence-Based Problem Solving

Assessment 3: Case project?part 1

Guideline and Marking Rubric

Due?date: Week?5:?11.59am,?Friday?15th??March?

Project Overview

You?area?consultant?at?Solution-X,?a?leading?consulting firm well-regarded for?its?innovative?and?comprehensive?problem-solving?solutions?that?blend?analytical?scrutiny,?statistical?insights, and ethical considerations.

We've partnered with GreenMart, aretail supermarket?chain facing a?pressing issue: a?notable increase in food waste, especially in the fresh food (Fruit and Vegetable)

section. GreenMart is eager to delve into the root causes of?this waste surge and?seeks actionable recommendations to tackle the?problem head-on.

GreenMart's fresh food section, brimming with fruits, veggies, dairy, meat, seafood,?and bakery delights. Yet, arising trend in food waste threatens to dampen the

excitement. Whether it's items nearing expiry, facing damage, falling short of?quality?standards, or spoiling due to storage mishaps, the waste is both a financial setback?and an environmental headache.

Now, GreenMart isn't?just about?profits; they're deeply committed to operational

efficiency, reducing their environmental footprint, and championing sustainability.

Project Object

1.??Investigate the factors contributing to the?rise in food waste in GreenMart’s fresh?food section.

2.??Develop ?and ?present??well-considered ?and??actionable??recommendations??to?GreenMart?to?assist?them?in?implementing?effective?strategies?to?reduce?food?waste.

Your Role and Responsibilities

Solution-X?has formed a team of?consultants?and business analysts to?provide thorough

analysis and actionable recommendations to GreenMart.?At the?project's end, we'll compile a?comprehensive?report. Your?role, assigned?by?the?team?lead, is?crucial?to?crafting?practical

solutions. Let's get started on making a insightful business analysis report.

Your?Tasks:

Assessment 3: Preliminary Analysis Pack (25%):

????Prepare?a preliminary business?analysis?report?for an?internal?meeting?on?the?rise?in?food?waste?at?GreenMart's?fresh?food?section.?Use?analytical,?statistical,?and?ethical?tools?to?understand the drivers behind this increase. This analysis will guide discussions and shape?future solutions.

????Focus?Areas:

- ???Analytical ?Toolbox:?Identify potential?factors?and?drivers?contributing?to?the?food?waste?problem.

- ????Statistical?Toolbox: Examine?the?data?provided?by?GreenMart?to?identify?food?waste trends and patterns.?This analysis will aid in pinpointing the potential causes of the?issues, directing more detailed analysis, and focusing?solution?development?on?key?issues to?prioritise?your?problem-solving effort.

- ????Ethics?Toolbox: Identify?any?ethical?dilemmas?associated?with?food?waste

? ??Word limit: ?1,500?words?(excluding graphs,?figures,?and reference?list). An?additional?10% buffer?(1,500 +?150 words) will be applied if?you exceed the word count. ???Structure?and?Format:?An?introduction?or?executive?summary?is?NOT?required. ?You?should?structure?your responses to directly answer each question?in the Initial?Analysis Pack.?Write in a?business?report?style, utilizing formal?language,?clear?headings,?and?subheadings?to organize?your?responses to each question.?The clarity,?coherence,?and?organization?of?your report?are?crucial,?and each section should be?well-integrated to offer?comprehensive?insights?into?the?addressed?questions. ???Referencing Style: Please use the Harvard referencing style. for any sources?cited in?your report?(seeThe 'In-Text' or Harvard methodfor?more information).

Guidelines for your Business Report

Section?1: Scoping the Problem Using the Analytical?Toolbox?(40%):

This?section?is?approximately?600 words?(guide?only, not?a?word?limit).

1)??Define?the?Problem:?Define?the?problem?concisely?to?provide?clarity?on?the?main?issue?requiring resolution for this assignment.

2)??Scope?the?Problem:?Utilize?the?5Ws?framework?(What,?Where,?When,?Who,?Why)?to?frame?and scope the problem. For each?'W',?formulate?questions to?explore?various?dimensions?of the problem?and identify evidence required?to?substantiate?the?answers.?Choose?only?two 'Ws'for?your report.

Instruction: ?Use??the??table??below??to??organise?your??questions, ?evidence, ?and??types??of evidence.?You?are?required?to?provide?at?least?three?points?for?two?‘W’s?(you?can?choose any 2 “W”?sfrom the 5?W).

Please integrate the 5W?table?provided directly into?your?report and type out?your?response?as text.?All content within the table will count towards the?1,500-word limit, so avoid using?screenshots

2ws	Questions to Explore the Proble	Identified Evidence	Type of Evidence
W..	1.?2. 3.	1.?2. 3.	1.?2. 3.
W..	1.?2. 3.	1.?2. 3.	1.?2. 3.

3)??Break?Down?the?Problem?Using?a?Logic?Tree: ?Construct?a?logic?tree?to?systematically?analyse?the increase in?food?waste at?GreenMart,?dividing?the problem?into?its parts?and?sub-parts to?pinpoint specific areas of?concern and contributing drivers.?Instruction:

a)???Include?a?clearly?labelled?logic?tree?in?your?submission. The?tree?needs?to?meet?the Mutually?Exclusive, Collectively?Exhaustive?(MECE) Requirements.

Instructions?for?creating?a?clear logic?tree?using?PowerPoint?are?available?on?our?course?Moodle?page?(Week?2's?folder).?Ensure?all?details?in?your?logic?tree?are?clearly visible. Marks maybe deducted if?your tutor cannot read the details due to?blurriness.?Attach?your logic tree as animage to?your report.?The logic tree image?will NOT count towards the?1,500-word limit.

b)??Prioritisation:?Determine?and?justify?which?branches?and/or sub-branches?should?be?prioritized?for?further?analysis.?Ensure?coherence?between?the?logic?tree?and?provide explanation to detail?your analytical?process,?providing a clear rationale for?your choices.

Section 2:?Gaining Insights Using the Statistical?Toolbox (40%):

This?section?is?approximately?600 words?(guide?only, not?a?word?limit).

Context:

After presenting your logic?tree?and having?a?detailed?discussion?with?GreenMart,?it has?been?identified?that?a?substantial?portion?of?the?increase?in?food?waste?is?due?to?an?abundance of freshly packed fruits and vegetables reaching their expiration dates before?being sold.?This insight has refined the?focus of?your investigation, necessitating?a?more?targeted analysis to comprehend the waste generated from these specific items.

GreenMart?has?shared?a?dataset?with?you,?concentrating?on?these?two?food?items.?A?detailed description of?the dataset is?provided on?page6.

Order?Details: Each?record?in?the?Excel?dataset?represents?a?single?order,?comprising?150?pre-packed?fruits?and?vegetable?items.?The?dataset provides?insights?into?the?quantities?wasted due to items remaining unsold before their expiration date

GreenMart Food?Waste Allowance?Target:?GreenMart’s food?waste allowance percentage for?fruit?is?capped?at?6.67%,?implying?that?in?any?given?order?of?150?pre-packed?fruit?items,?a?maximum?of?10?items?should?be?wasted?due?to?reaching?expiration?before?being?sold.?The?waste?percentage for vegetable is capped at?12% (amaximum of 18 Items per order).

GreenMart's Operational Protocols:?When orders arrive at the?GreenMart?retail?store,?they are?initially placed in?the storage area before?being?stocked?on?the?shelves?for?sale.?Operational?protocols?with?specific?targets?for?shelving?fresh?food?items?are?implemented?to?optimize?the?availability of fresh?products to customers while minimizing waste due to expiration.

- ????For fruit:?Target is to?have?the?items?on?the?shelf for at?least?7?days before?the?expiry?date,given an expiration date of 12 days?post-arrival at the storage area.

- ????For?vegetable:?Target is to?have?the?items?on?the?shelf?for?at?least?5?days?before?the?expiry date, given an expiration date of?8 days post-arrival at the storage area.

Statistical?Toolbox?Analysis Instructions:

1)??Analyse Food?Waste:

a)??Summary?Statistics: Calculate?the?mean, and?standard?deviation?of?food?waste (variable?"Quantity_Wasted")?for?fruits?and?vegetables.?Then,?compare?these results with GreenMart’s food waste allowance target

b)??Monthly?Analysis: ?Create?pivot?tables?in?Excel?to?conduct?a?monthly?analysis of?fruits?and?vegetables?waste, using?the?variable?"Order_Arrival_Date" to

determine the order month. Choose an appropriate visual representation?you?see fit to showcase this result in?your report.

2)??Investigate Logistic Issues and Shelf Time

Management?at?GreenMart?suspects?that?logistic?issues?may?be?causing?delays?in?moving?items?from?storage?to?the?shelves. This?delay?could?reduce?the?display?time?of?food?items, contributing to?increased food waste due to?items?reaching their?expiration?dates?before?being?sold.

a) ??Create ?a ?new ?variable: ?Create??a??new??column??named??"Shelf_Duration"??to?calculate?the?shelf time?(in?days)?of each?order.?This?variable?represents?the?duration each order stays on the shelf?before expiration

Shelf_Duration = Expiration_Date_Of_Order – Inventory_Replenishment_Date

b)??Summary?Statistics?and?Monthly?Analysis:?Calculate?the?summary?statistics of?“Shelf_Duration” ?for??fruits??and??vegetables??separately. ?Then, ?perform??a monthly analysis and choose a suitable diagram to?present it in?your report.

3)??Analyse Number of Orders,?Prices,?and?Additional Insights

a) ??Order??and??Price??Analysis:??Select??suitable??statistical??analysis??tools??and?visualizations?(diagrams)?to examine the?trends in the?number?of orders?and?prices for fruits and vegetables overtime.

b) ??Create?another new column:?Now, you're required to?create?a?new?column?in?your?Excel?file. This?column?can?contain?any?information?you?consider?relevant,?ensuring that it's solely based on your existing Excel data.?Clearly?explain?the?rationale behind creating this new column and how?it can help?you?address?the?food?waste issue.?Furthermore, include a screenshot displaying?only the?first?10-15 ?rows??of??this??new??column. ?Insert??the??screenshot??into??your??report?alongside your explanation?for this?question.?The screenshot?does not count?towards the word count.

Instruction: Include clear?tables or?graphs to display?the?results of?each?statistical?analysis?part?(1-3). Ensure?they?are?well-labelled?and?easy?to?read. Provide?a?summary?of?the?main findings?from?your?analysis?above,?highlighting?key?insights?obtained.?Emphasize?their?relevance?to?helping?you?solve?the?food?waste?issue.?(Note:?Tables, Diagrams,?or?Graphs in?this?section?are?NOT?in?the?word?count)

Section 3:?Ethical Dilemmas with the Ethics?Toolbox (20%)

This?section?is?approximately?300 words?(guide?only, not?a?word?limit).

Select?astakeholder?impacted?by?GreenMart's food waste?issue.?Stakeholders?may?include?GreenMart, residents?and?consumers, the?Local?council, or?Regulatory?Agencies?like?ACCC,?waste management companies, or?product manufacturers.

Consider?one?ethical?dilemma?faced?by your?chosen?stakeholder?due?to?the?increase?in?food waste. Reflect on the various ethical concerns and challenges related to food waste?at??GreenMart. ?Assess??the??potential??harm???to??individuals???or??entities, ??such??as??the environment, and elaborate on?your reasoning (Please refer to our tutorial materials from?Week?4 for?additional?details?and?support).

Instruction:?Ensure?clarity?and?conciseness?in your?explanation,?focusing?on?the?ethical?implications??and??considerations??of ?the??identified ??dilemma??within??the??context??of?GreenMart's?food?waste?issue.

For?this?section, you?are?NOT?required?to?apply?the?full?7-step?Ethical?Decision-making Framework; your?task?is?merely?to?identify?one?potential?ethical?dilemma?related?to?the food waste issue at GreenMart, considering the?perspective of?your chosen stakeholder.

?

?