Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do it in 55 minutes please urgently... I'll give you up thumb definitely estion 10 -t yet swered arked out of DO Flag estion
please do it in 55 minutes please urgently... I'll give you up thumb definitely
estion 10 -t yet swered arked out of DO Flag estion Use the spreadsheet extract to answer the questions C A D E 1 Materials budgets: 50mm x 20mm pine 2 3 September October November Total 4 5 units units units units 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Usage budget Production of tables Raw material usage Purchases budget Production usage Add: closing stock Less: opening stock Purchases Raw material purchases Raw materials data Usage per unit of production (metres) Purchase price per metre ($) 250 metres metres 625 625 28 (25) 628 $ 5903.20 2.5 9.40 280 metres 700 metres 700 29 (28) 701 $ 6589.40 290 metres 725 metres 725 30 (29) 726 820 metres metres ? ? ? 2055 $ $ 6824.40 19317.00 F 27 28 Assumptions 29 1 The closing stock in one month is 4% of the following month's production requirement 30 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadsheet? Choose... Suggest a formula for the following: C16; Choose... The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E15: Choose... + E16: Choose... # Required Which of the following cells require the input of an actua on the spreadsheet? Choose... Choosk... Suggest a formula fo ng: B15 C16; Choose... C10 C7 The total column has B16 ompleted. Match up the c complete this column. E15: Choose... + E16: Choose... Suggest a formula for the following: C16 Choose... Choose... The t =-B15 or -C14*0.04 comp =SUM(D14:D16) E15: D10 or =D7*B25 E16: =D7+B25 =D10*D7 =C17*826 or =C17*$B$26 complete ious page The total column has yet to be completed. M complete this column. E15: Chode... Choose... E16: =E10 =SUM(B16:D16) =D15 =B15 =SUM(B10:D10) =D16 =B16 =SUM(B10:E10) =SUM(B15:D15) Type here to search page complete this column. E15: Choose... E16: Choose... Choose... =E10 =SUM(B16:D16) =D15 =B15 =SUM(B10:D10) =D16 =B16 =SUM(B10:E10) =SUM(B15:D15) TypeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started