computer simulation control option 5.

Affiliates: 0,12 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 0
Refunds: 0

Uploaded: 17.01.2013
Content: 141.zip (347,79 kB)

Description

Task №22

Objective:
In the log of transactions reflect the relevant business transactions, stating the necessary original documents.
Initial data:
Ltd. "Ray" 01.01.2011. It took the bank "Commercial" 2 month loan of 1,200 thousand. rub. under 18% per annum.
The loan was aimed at pre-payment materials. The cost of materials is 1180 thousand. Rub., Including VAT.
Materials obtained 11.02.2011g.
According to the loan agreement for the loan interest paid by the bank every month.
Task 2. Use of spreadsheets to solve financial problems

Option 5. Calculate the amount of payment for utility services in March 2000, when the apartment has an area of \u200b\u200b71.4 sq. m living 4 people. What is the share of each payment in the total amount?
Task 3. Balance models

Option 5. 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 gross output of industries in kind (X);
- 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.
Calculate scheme MPS next year, provided that the chemical industry is planning to increase your final product by 15%, and light industry - by 20%.

Initial data:

1.49 0.39 0.52 0.35 0.37 0.38
0.58 1.46 0.49 0.41 0.42 0.53
B = 0.37 0.31 1.39 0.36 0.38 0.37
0.44 0.43 0.49 1.36 0.44 0.53
0.40 0.33 0.39 0.45 1.37 0.39
0.49 0.37 0.45 0.38 0.46 1.39

X = (670 470 580 650 420 370)

P = (180 150 175 185 190 140),
Task 4. "Optimization models"

Task 5. The company produces two kinds of ice cream: butter and chocolate. For the production of ice cream using two starting materials: milk and excipients which costs per 1 kg of the final product and their daily stock are shown in Table. The daily demand for ice cream exceeds the demand for chocolate is not more than 100 kg. In addition, the demand for chocolate ice cream does not exceed 350 kg. Selling price of 1 kg of ice cream, 16 p., 14 p-chocolate. Is required to determine how much of each type of ice cream should produce company to revenues from product sales were the highest.
Input data are given in the table.

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.)