Swafford_bmas_p9_59a_start(Read-Only] - Excel VIEW REVIEW Wrap Text General - 35.. FILE HOME INSERT PAGE LAYOUT FORMULAS DATA X Cut Calibri -12 AA == Paste forma BIU- - -A- Clipboard Font B8 X fx Din Copy Merge & Center - S. % 9 Conditional Formatting Number F A B C D E 1 The Master Budget 2 Comprehensive summary problem Birdfeeders Unlimited makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores. $15 Sales price per birdfeeder 1.5 Board feet of wood required for each birdfeeder $4 Cost per board foot (actual) 10% Desired ending wood inventory stated as a percentage of next month's production requirements 20% Desired ending finished goods Inventory (finished birdfeeders) stated as a percentage of next month's sales $550,000 Total cost of direct materials purchases in December 45% of direct materials purchases are paid in the month of purchase 55% of direct materials purchases are paid in the month after purchase 15 Sales data for the company can be found on the "SALESDATA" tab. 17 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use coll references and formulas where appropriate to receive full credit. If you 18 copy/paste from the Instruction tab you will be marked wrong 20 Requirements 1 Prepare the sales budet. Including a separate section that details the type of sales made INSTRUCTIONS SALESDATA ENTERANSWERS DELL Format Painter TU. . Merge & Center. 5.% . Conditiona Formatting Cupboard Font Alignment Number 873 X fx 1st Quarter 265,000 Birdfeeders Unlimited Direct Materials Budget For the Quarter Ended March 31 Month January February March 39 Units (birdfeeders) to be produced 80.000 90.000 95.000 40 Multiply by: Quantity (board feet) of DM needed per unit 1.5 1.5 1.5 41 Quantity (board feet) needed for production 120,000 135,000 142,500 42 Plus: Desired ending inventory of DM 13,500 14.250 15.750 43 Total quantity (board feet) needed 133.500 149.250 158,250 44 Less: Beginning inventory of DM 12,000 13,500 14.250 45 Quantity (board feet) to purchase 121,500 135,750 144,000 46 Multiply by: Cost per board foot $4.00 $4.00 $4.00 47 Total cost of DM purchases $486.000 $543,000 $576,000 1.5 397,500 15,750 413,250 12.000 401,250 $4.00 $1,605,000 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first 49 quarter. (Always use cell references and formulas where appropriate to recelve full credit. Use cell references from previous calculations and requirements, if applicable. If you copy/paste from the Instruction tab you will be 50 marked wrong.) Birdfeeders Unlimited Cash Collections Budret ENTERANSWERS INSTRUCTIONS SALESDATA READY DOLL unde LOW E R 46 Multiply by: Cost per board foot $4.00 $4.00 $4.00 $4.00 47 Total cost of DM purchases $486,000 $543,000 $576,000 $1,605,000 48 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first 49 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 Instruction tab you will be 50 marked wrong.) 1st Quarter + Birdfeeders Unlimited Cash Collections Budget For the Quarter Ended March 31 Month January February March 57 Cash sales in current month 58 Collection on credit sales: 59 Credit sales made one month ago 60 Credit sales made two months ago 61 Credit sales made three months ago 62 Total cash collections 5. Prepare the cash payments budget for direct materials purchases for the months of January, February 64 and March, as well as a summary for the first quarter. INSTRUCTIONS SALESDATA ENTERANSWERS READY Otiga e XI DOLL Tab Caps Lock ASDFGH 5. Prepare the cash payments budget for direct materials purchases for the months of January, February 64 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 Instruction tab you will be 65 marked wrong.) Birdfeeders Unlimited Cash Payments for Direct Materials Purchases For the Quarter Ended March 31 Month January February March 72 Total cost of DM purchases $486,000 $543,000 $576,000 73 Cash payments for current month purchases 74 Cash payments for prior month purchases 75 Total cash payments 1st Quarter $1,605,000 INSTRUCTIONS SALESDATA INTERANSWERS DOLL W E RT S D 1 F G Caps Lock A H