Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Company Accounting

Authors: Ken Leo, Jeffrey Knapp, Susan McGowan, John Sweeting

11th Edition

0730344770, 9780730344773

More Books

Students also viewed these Accounting questions