Hi,
i want to know about my business simulation that what should be my period 15 assumptions:
Price, Dividend, Marketing, Research & Development, Maintenance Budget, Material Purchased and Investment in Plant & Equipment
Period 13 JAS Price Index 119.7 Forecast, Annual Change 43% Seas. Index 96 Next Qtr. 115 Econ. Index 104 Forecast, Next Qtr. 104 Information on Competitors Price Dividend Market Share Profit Firm 1 24.50 $ 50,000 15.0% (39,663) Firm 2 24.50 S 35,000 137% 27,750 Firm 3 24.59 $ 55,000 21.0% 190,011 Firm 4 25.55 S 60,000 14.9% 64,112 Firm 5 25.05 $ 65,000 17.4% 100,090 Firm 6 24.75 $ 40,000 18.0% 100,247 Firm 4 Operating Statements Market Potential 130.522 Sales Volume 123.264 Market Share 14.9% Production this Quarter 120,000 Inventory Finished Goods Plant Capacity, Next Quarter 148,890 Income Statement Receipts, Sales Revenues $ 3,149,404 Expenses Marketing $ 152.250 Research & Development 100,000 Administration 386,397 Maintenance 109,200 Labour (Cost/Unit ex. O/T $6.93 832.084 Material Consumed (Cost/Unit $7.35) 881,549 Reduction, Finished Goods Inv. 45,432 Plant & Eq. Depreciation (2.5%) 248,643 Finished Goods Carrying Costs Raw Materials Carrying Costs 57,500 Ordering Costs 58.843 Investment Expenses 49,000 Financing Charges and Penalties Sundries 131,366 3,052 264 Profit Before Income Tax $ 97,140 Income Tax 33.028 Net Profit After Tax $ 64.112 Dividends Paid 60,000 Addition to Owners Equity $ 4,112 Cash Flow Statement Receipts, Sales Revenues $ 3,149,404 Disbursements Cash Expense $ 1,876,640 Income Tax Paid 33,028 Dividends Paid 60.000 Pland & Eq. Investment 700,000 Materials Purchased 900,000 3,569,668 Addition to Cash Assets $ (420,264) Balance Sheet Net Assets Cash 16,012 Inventory, Finished Goods Inventory, Raw Materials 1,168,451 Plant & Eq. (Replacement Value $ 12474,793 ) 10,397.073 Owners Equity (Economic Equity $ 13,659,256 ) 1 1,581,536Period 14 OND Price Index 121.4 Forecast, Annual Chang 3.3% Seas. Index 115 Next Qtr. 90 Econ. Index 106 Forecast, Next Qtr. 102 Information on Competitors Price Dividend Market Share Profit Firm 1 24.50 $ 45,000 13.7% (64,013) Firm 2 25.50 $ 50,000 127% 66,408 Firm 3 24.59 55,000 19.6% 172,600 Firm 4 25.30 16.7% 162,258 Firm 5 24.80 60,000 16.2% 7.240 Firm 6 24.75 45,000 21.0% 222.944 Firm 4 Operating Statements Market Potential 179,297 Sales Volume 149,000 Market Share 16.7% Production this Quarter 149,000 Inventory Finished Goods Plant Capacity, Next Quarter 148,853 Income Statement Receipts, Sales Revenues $ 3,769,700 Expenses Marketing $ 170,000 Research & Development 100,000 Administration 459,871 Maintenance 80,000 Labour (Cost/Unit ex. O/ $7.23) 1,077,416 Material Consumed (Cost/Un $7.48) 1,113,945 Reduction, Finished Goods Inv. Plant & Eq. Depreciation (2.5%) 259,927 Finished Goods Carrying Costs Raw Materials Carrying Costs 58,423 Ordering Costs 59.845 Investment Expenses 6,250 Financing Charges and Penalties Sundries 138,177 3,523,855 Profit Before Income Tax $ 245,845 Income Tax 83,587 Net Profit After Tax $ 162,258 Dividends Paid Addition to Owners Equity $ 162,258 Cash Flow Statement Receipts, Sales Revenues $ 3,769,700 Disbursements: Cash Expense $ 2,149,982 Income Tax Paid 83,587 Dividends Paid Pland & Eq. Investment 250,000 Materials Purchased 1,150,000 3,633,570 Addition to Cash Assets $ 136,130 Balance Sheet Net Assets Cash $ 152,142 Inventory, Finished Goods Inventory, Raw Materials 1,204,506 Plant & Eq. (Replacement Value $ 12,654,418 ) 10,387,146 Owners Equity (Economic Equity $ 14,011,066 ) 11,743,794
