Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Systems Audit Risk Mitigation

Authors: Mr Indulis L Svikis

1st Edition

B084DGQJJ5, 979-8607031909

More Books

Students also viewed these Accounting questions

Question

What is Larmors formula? Explain with a suitable example.

Answered: 1 week ago