Answer:
Lock the Formulas Cells
Explanation:
Now, go to lock the selected cells with formulas. To do this, press Ctrl - 1 to open the Format Cells dialog again, switch to the Protection tab, and check the Locked checkbox. The locked option prevents the user from overwriting, deleting or changing the content of the cells.
Answer:
![\left[\begin{array}{ccccc}&January&February&March&Quarter\\$sales&24500&37700&32500&94700\\$Desired ending&9425&8125&3462.5&3462.5\\$Total Needs&33925&45825&35962.5&115712.5\\$beginning&2770&9425&8125&2770\\$Production Requirement&31155&36400&27837.5&95392.5\\\end{array}\right]](https://tex.z-dn.net/?f=%5Cleft%5B%5Cbegin%7Barray%7D%7Bccccc%7D%26January%26February%26March%26Quarter%5C%5C%24sales%2624500%2637700%2632500%2694700%5C%5C%24Desired%20ending%269425%268125%263462.5%263462.5%5C%5C%24Total%20Needs%2633925%2645825%2635962.5%26115712.5%5C%5C%24beginning%262770%269425%268125%262770%5C%5C%24Production%20Requirement%2631155%2636400%2627837.5%2695392.5%5C%5C%5Cend%7Barray%7D%5Cright%5D)
Explanation:
We need to recalcualte the desired ending inventory
as currently they are calcualte at 20% and we want it at 25% we do cross multiplication
Jan: 7,540 / 20 x 25 = 9,425
We divide by 20 to get the value of a single percent f sales and then we multiply to 25 as it is our desired amount
Feb: 6,500 / 20 x 25 = 8,125
March: 2,770 / 20 x 25 = 3,462.5
Next we adjsut6 the beginning inventory for January as it is 2,770 instead of 4,900 and we can determiante the production budget need for the quarter
Answer:
Line and staff structure
Explanation:
Line and staff structure is an organisational structure where we have line managers that set up goals and directives that are now executed by staff assigned to the line managers.
This is usually used in large organisations and is aimed maintaining managerial authority.
A breakdown of this structure is:
- Line function is the core directive of a manager according to his own departmental goals.
- Staff function is one that supports the line manager with specialised advisory and support functions.
Answer:
Total fixed cost $16,000
unit fixed cost for 10,000 units $1.60
Explanation:
the budget was made for 8,000 units
so the 2.00 dollars for fixed cost will be based on a production for 8,000 units
total fixed cost: 8,000 budgeted units x $2 per unit = 16,000
This is the level of fixed cost.
<u>For 10,000 units the total fixed cost should be the same.</u>
and for units it will be total cost / units of production
16,000 / 10,000 = 1.6
On unit-level it will drop by 40 cent to $1.60 from $2.00
