Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you let me know how you are getting the numbers abd which numbers you are using for each cell? thank you ! 3. Prepare

could you let me know how you are getting the numbers abd which numbers you are using for each cell? thank you !
image text in transcribed
image text in transcribed
image text in transcribed

3. Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for the quarter. Assume the company needs 120,000 board feet of wood for production in April. (Always use cell references and formulas where appropriate to receive full credit. Use cell references from prior requirements and calculations, if applicable. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Birdfeeders Unlimited Direct Materials Budget For the Quarter Ended March 31 Units (birdfeeders) to be produced Multiply by: Quantity (board feet) of DM needed per unit Quantity (board feet) needed for production Plus: Desired ending inventory of DM Total quantity (board feet) needed Less: Beginning inventory of DM Quantity (board feet) to purchase Multiply by: Cost per board foot Total cost of DM purchases Month January February March 82,000 91,000 97,000 1.5 123,000 1.5 136,500 1.5 1st Quarter 270,000 1.5 145,500 425,000 13,650 14,550 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter. (Always use cell references and formulas where appropriate to receive full credit. Use cell references from previous calculations and requirements, if applicable. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wenne

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

College Accounting

Authors: Heintz and Parry

20th Edition

1285892070, 538489669, 9781111790301, 978-1285892078, 9780538489669, 1111790302, 978-0538745192

More Books

Students also viewed these Accounting questions

Question

What is ethics? LO56

Answered: 1 week ago

Question

11. To compromise is to take the easy way out of conflict.

Answered: 1 week ago