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.
- 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%?
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.