# computer simulation version 9 control.

Affiliates: 0,11 \$how to earn
Sold: 0
Refunds: 0

Uploaded: 17.01.2013
Content: 142.zip (367,27 kB)

# Description

Task 2. Use of spreadsheets to solve financial problems

Option 9. Using advertising media (newspaper "Advertising"), to analyze the costs of advertising of goods and services in Tomsk in different directions. The cost of advertisements in the newspaper "Advertising" (in rubles per 1 sq. Cm): front page - 29 last band - 18, the band with the program TV - 15 regular band - 9.8 (these data to issue a separate table and reference address them through cells).
Task 3. Balance models

Option 9. consider the economic system, which consists of six fields: mechanical engineering, chemical industry, light industry, food industry, construction and agriculture.
There are:
- Matrix of coefficients of total material costs in kind (B);
- Vector of the final product in the natural form (V);
- The vector of prices of products industries (P).
Check the balance of the price system of units of production (if the condition is not satisfied, offer the event to change the situation and will amend the price).
Build scheme interbranch balance in kind and value terms.
Determine the change in the structure of gross output by reducing the ratio of direct costs of the 4th sector in the production 2nd industry by 14%.
How will the added cost if you plan for the next year to raise the price first and fifth branches respectively 10% and 15%?

Initial data:

1.65 0.37 0.51 0.44 0.48 0.35
0.48 1.44 0.42 0.38 0.32 0.43
B = 0.36 0.48 1.28 0.34 0.36 0.42
0.43 0.42 0.46 1.24 0.42 0.30
0.38 0.32 0.41 0.42 1.26 0.34
0.42 0.39 0.41 0.38 0.44 1.41

Y = (400 570 430 750 520 380)

P = (170 180 150 175 125 160) is
Task 4. "Optimization models"

Task 9. electronics industry produces two models of radios, each model is produced on a separate production line. The daily output of the first line - 60 articles, the second line - 75 products. In the first model consumes radio 10 same elements of electronic circuits, on the second radio model - 8 the same elements. The maximum daily supply of used items is equal to 800 units. Profits from the sale of the radio first and second models is 30 and \$ 20., Respectively. Determine the optimal daily amount of production of the first and second models.

# Feedback

0
No feedback yet.
 Period 1 month 3 months 12 months 0 0 0 0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)