Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the spreadsheet extract to answer the questions D E F B Materials budgets: 50mm x 20mm pine September October November Total Usage budget units
Use the spreadsheet extract to answer the questions D E F B Materials budgets: 50mm x 20mm pine September October November Total Usage budget units units units units Production of tables 250 280 290 820 Raw material usage metres 625 metres 700 metres 725 metres ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Purchases budget Production usage Add: closing stock Less: opening stock Purchases metres 625 28 (25) 628 metres 700 29 (28) 701 metres 725 30 (29) 726 metres ? ? ? 2055 $ $ $ $ Raw material purchases 5903.20 6589.40 6824.40 19317.00 Raw materials data Usage per unit of production (metres) Purchase price per metre ($) 2.5 9.40 Assumptions 1 The closing stock in one month is 4% of the following months production requirement 2 From December onwards production of tables will plateau at 290 30 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: C21; Choose... The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E14 Choose... E16: Choose
Step 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