Final report

nirmak

Round0Results.docx

Home >Business & Finance homework help >Operations Management homework help >Final report

Round 0 Results

Contents

· Section 1 Research and Development

· Section 2 Marketing Low Tech

· Section 3 Marketing High Tech

· Section 4 Production

· Section 5 Finance

· Section 6 Product Financials

· Section 7 Custom Modules

High Level Overview

High Level Overview
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris	Average
Sales	$31,500	$31,500	$31,500	$31,500	$31,500	$31,500	$31,500
Profit	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)
Contribution Margin	5.48%	5.48%	5.48%	5.48%	5.48%	5.48%	5.48%
Stock Price	$4.59	$4.59	$4.59	$4.59	$4.59	$4.59	$4.59
Emergency Loan	$0	$0	$0	$0	$0	$0	$0
Market Share	16.7%	16.7%	16.7%	16.7%	16.7%	16.7%	16.7%

Section | Research and Development

Low Tech
Customer Buying Criteria	Expectations	Importance
Price	$15.00 - $35.00	41%
Age	3 Years	29%
Reliability	14,000 - 20,000 Hours	21%
Positioning	Performance 4.8 Size 15.2	9%
High Tech
Customer Buying Criteria	Expectations	Importance
Positioning	Performance 7.4 Size 12.6	33%
Age	0 Years	29%
Price	$25.00 - $45.00	25%
Reliability	17,000 - 23,000 Hours	13%

Perceptual Map

PerformanceSizeAbleAbleBakerBakerCakeCakeDazeDazeEatEatFastFast0246810121416182002468101214161820

Product List
Name	Performance	Size	Reliability	Age	Revision Date
Able	6.4	13.6	21,000	3.1	November 25, 2018
Baker	6.4	13.6	21,000	3.1	November 25, 2018
Cake	6.4	13.6	21,000	3.1	November 25, 2018
Daze	6.4	13.6	21,000	3.1	November 25, 2018
Eat	6.4	13.6	21,000	3.1	November 25, 2018
Fast	6.4	13.6	21,000	3.1	November 25, 2018

Section | Marketing

Low Tech

Customer Buying Criteria
Categories	Expectations	Importance
Price	$15.00 - $35.00	41%
Age	3 Years	29%
Reliability	14,000 - 20,000 Hours	21%
Positioning	Performance 4.8 Size 15.2	9%
Demand Information
2021 Total Market Size	3,780
2021 Total Units Sold	3,780
2022 Demand Growth Rate	10%

Market Share

Andrews16.7 %Andrews16.7 %Baldwin16.7 %Baldwin16.7 %Chester16.7 %Chester16.7 %Digby16.7 %Digby16.7 %Erie16.7 %Erie16.7 %Ferris16.7 %Ferris16.7 %AndrewsBaldwinChesterDigbyErieFerrisErie: 16.7%

Top Products
Name	Price	Units Sold	Potential Sold	Stock Out	Sales Budget	Customer Accessibility	Promo Budget	Customer Awareness	Customer Satisfaction
Able	$35.00	630	630	No	$1,000	40%	$1,000	55%	16
Baker	$35.00	630	630	No	$1,000	40%	$1,000	55%	16
Cake	$35.00	630	630	No	$1,000	40%	$1,000	55%	16
Daze	$35.00	630	630	No	$1,000	40%	$1,000	55%	16
Eat	$35.00	630	630	No	$1,000	40%	$1,000	55%	16
Fast	$35.00	630	630	No	$1,000	40%	$1,000	55%	16

Section | Marketing

High Tech

Customer Buying Criteria
Categories	Expectations	Importance
Positioning	Performance 7.4 Size 12.6	33%
Age	0 Years	29%
Price	$25.00 - $45.00	25%
Reliability	17,000 - 23,000 Hours	13%
Demand Information
2021 Total Market Size	1,620
2021 Total Units Sold	1,620
2022 Demand Growth Rate	20%

Market Share

Andrews16.7 %Andrews16.7 %Baldwin16.7 %Baldwin16.7 %Chester16.7 %Chester16.7 %Digby16.7 %Digby16.7 %Erie16.7 %Erie16.7 %Ferris16.7 %Ferris16.7 %AndrewsBaldwinChesterDigbyErieFerris

Top Products
Name	Price	Units Sold	Potential Sold	Stock Out	Sales Budget	Customer Accessibility	Promo Budget	Customer Awareness	Customer Satisfaction
Able	$35.00	270	270	No	$1,000	41%	$1,000	55%	15
Baker	$35.00	270	270	No	$1,000	41%	$1,000	55%	15
Cake	$35.00	270	270	No	$1,000	41%	$1,000	55%	15
Daze	$35.00	270	270	No	$1,000	41%	$1,000	55%	15
Eat	$35.00	270	270	No	$1,000	41%	$1,000	55%	15
Fast	$35.00	270	270	No	$1,000	41%	$1,000	55%	15

Section | Production

Production vs Capacity

1,1091,1091,1091,1091,1091,1091,1091,1091,1091,1091,1091,1091,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,000ProductionCapacityAndrewsBaldwinChesterDigbyErieFerris0100200300400500600700800900100011001200Production: 1,109

Plant Information
Name	Primary Segment	Units Produced	Units Sold	Inventory	Price	Material Cost	Labor Cost	Contribution Margin	Auto. Next Round	Capacity Next Round	Plant Utilization
Able	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%
Baker	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%
Cake	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%
Daze	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%
Eat	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%
Fast	Low Tech	1,109	900	209	$35.00	$16.17	$14.41	5.5%	3	1,000	160%

Section | Finance

Income Statement
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris
Sales	$31,500	$31,500	$31,500	$31,500	$31,500	$31,500
Variable Costs
Direct Material	$15,170	$15,170	$15,170	$15,170	$15,170	$15,170
Direct Labor	$12,971	$12,971	$12,971	$12,971	$12,971	$12,971
Inventory Carry	$1,634	$1,634	$1,634	$1,634	$1,634	$1,634
Total Variable Costs (Labor, Material, Carry)	$29,775	$29,775	$29,775	$29,775	$29,775	$29,775
Contribution Margin	$1,725	$1,725	$1,725	$1,725	$1,725	$1,725
Period Costs
Depreciation	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200
SG&A
R&D	$0	$0	$0	$0	$0	$0
Promotions	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000
Sales	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000
Administration	$563	$563	$563	$563	$563	$563
Total Period Costs	$3,763	$3,763	$3,763	$3,763	$3,763	$3,763
Net Margin	($2,038)	($2,038)	($2,038)	($2,038)	($2,038)	($2,038)
Other (Fees/Write-offs/Bonuses/Relocation Fee)	$0	$0	$0	$0	$0	$0
EBIT	($2,038)	($2,038)	($2,038)	($2,038)	($2,038)	($2,038)
Interest (Short term/Long Term)	$814	$814	$814	$814	$814	$814
Taxes	($998)	($998)	($998)	($998)	($998)	($998)
Profit Sharing	$0	$0	$0	$0	$0	$0
Net Profit	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)
Cash Flow Statement
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris
Starting Cash Position	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000
Cash From Operations
Net Income(Loss)	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)	($1,854)
Adjustment For Non-Cash Items
Depreciation	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200
Extraordinary Gains/Losses/Write-offs	$0	$0	$0	$0	$0	$0
Changes In Current Assets And Liabilities
Accounts Payable	$850	$850	$850	$850	$850	$850
Inventory	($6,534)	($6,534)	($6,534)	($6,534)	($6,534)	($6,534)
Accounts Receivable	$4,411	$4,411	$4,411	$4,411	$4,411	$4,411
Net Cash From Operations	($1,927)	($1,927)	($1,927)	($1,927)	($1,927)	($1,927)
Cash From Investing
Net Plant Improvements	$0	$0	$0	$0	$0	$0
Cash From Financing
Dividends Paid	($1,000)	($1,000)	($1,000)	($1,000)	($1,000)	($1,000)
Sales Of Common Stock	$0	$0	$0	$0	$0	$0
Purchase Of Common Stock	$0	$0	$0	$0	$0	$0
Cash From Long-Term Debt Issued	$0	$0	$0	$0	$0	$0
Early Retirement Of Long-Term Debt	$0	$0	$0	$0	$0	$0
Retirement Of Current Debt	$0	$0	$0	$0	$0	$0
Cash From Current Debt Borrowing	$0	$0	$0	$0	$0	$0
Cash From Emergency Loan	$0	$0	$0	$0	$0	$0
Net Cash From Financing	($1,000)	($1,000)	($1,000)	($1,000)	($1,000)	($1,000)
Effect Of Exchange Rates	$0	$0	$0	$0	$0	$0
Net Change In Cash	($2,927)	($2,927)	($2,927)	($2,927)	($2,927)	($2,927)
Ending Cash Position	$2,073	$2,073	$2,073	$2,073	$2,073	$2,073

Balance Sheet
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris
Cash	$2,073	$2,073	$2,073	$2,073	$2,073	$2,073
Accounts Receivable	$2,589	$2,589	$2,589	$2,589	$2,589	$2,589
Inventory	$6,534	$6,534	$6,534	$6,534	$6,534	$6,534
Current Assets	$11,196	$11,196	$11,196	$11,196	$11,196	$11,196
Plant and Equipment	$18,000	$18,000	$18,000	$18,000	$18,000	$18,000
Accumulated Depreciation	($6,000)	($6,000)	($6,000)	($6,000)	($6,000)	($6,000)
Fixed Assets	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000
Total Assets	$23,196	$23,196	$23,196	$23,196	$23,196	$23,196
Accounts Payable	$2,850	$2,850	$2,850	$2,850	$2,850	$2,850
Current Debt	$0	$0	$0	$0	$0	$0
Current Liabilities	$2,850	$2,850	$2,850	$2,850	$2,850	$2,850
Long-Term Liabilities	$6,600	$6,600	$6,600	$6,600	$6,600	$6,600
Total Liabilities	$9,450	$9,450	$9,450	$9,450	$9,450	$9,450
Common Stock	$2,904	$2,904	$2,904	$2,904	$2,904	$2,904
Retained Earnings	$10,842	$10,842	$10,842	$10,842	$10,842	$10,842
Total Equity	$13,746	$13,746	$13,746	$13,746	$13,746	$13,746
Total Liabilities & Equity	$23,196	$23,196	$23,196	$23,196	$23,196	$23,196
Stock Market Summary
Company	Closing Price	Change	Shares Outstanding	Market Cap	Book Value	EPS	Dividend	Yield	P/E
Andrews	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96
Baldwin	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96
Chester	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96
Digby	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96
Erie	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96
Ferris	$4.59	$0.00	2,000,000	$9m	$6.87	($0.93)	$0.50	10.9%	-4.96

Bond Market Summary
Company	Series	Face Value	Yield	Closing Price	S&P Rating
Andrews	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Baldwin	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Chester	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Digby	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Erie	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Ferris	11.0S2023 12.0S2025 13.0S2027	$1,100,000 $2,200,000 $3,300,000	10.85% 11.35% 11.59%	$101.38 $105.68 $112.12	BBB BBB BBB
Next Year's Prime Rate: 7%

Stock Price

4.594.59AndrewsBaldwinChesterDigbyErieFerris20212022202320242025202620272028$0$10$20$30$40$50

Net Profit

AndrewsBaldwinChesterDigbyErieFerris$-2000$-1500$-1000$-500$0Erie: ($1,854)

Section | Product Financials

Andrews Income Statement
Category	Able	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)
Baldwin Income Statement
Category	Baker	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)

Chester Income Statement
Category	Cake	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)
Digby Income Statement
Category	Daze	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)

Erie Income Statement
Category	Eat	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)
Ferris Income Statement
Category	Fast	Other Info	Total
Sales	$31,500		$31,500
Variable Cost	$29,775		$29,775
Fixed Cost	$3,763		$3,763
Net Margin	($2,038)		($2,038)
		Other (Fees, Writeoffs)	$0
		Long Term Interest	$814
		Taxes & Tariffs	($998)
		Profit Sharing	$0
		Net Profit	($1,854)

WorkforceRound: 0 Dec. 31, 2021OP99075_1

Workforce Summary
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris
Number of Employees	308	308	308	308	308	308
First Shift	193	193	193	193	193	193
Second Shift	115	115	115	115	115	115
Overtime %	0%	0%	0%	0%	0%	0%
Turnover Rate	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%
New Employees	91	91	91	91	91	91
Separated Employees	0	0	0	0	0	0
Productivity Index	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%

Section | Custom Modules

Workforce Summary
Categories	Andrews	Baldwin	Chester	Digby	Erie	Ferris
Number of Employees	308	308	308	308	308	308
First Shift	193	193	193	193	193	193
Second Shift	115	115	115	115	115	115
Overtime %	0%	0%	0%	0%	0%	0%
Turnover Rate	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%
New Employees	91	91	91	91	91	91
Separated Employees	0	0	0	0	0	0
Productivity Index	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%