Home Soy 5 Insert start Draw Page Layout Formulas Data Review View Developer Help Search Is 12 Calibri BIL 33 E General A Wrap Text Merge & Center - Cipboard $ . % 93 Aliment Number A B C D E F G H I K L M 1 The Master Budget 2 Comprehensive summary problem 3 Birdfeeders Unlimited makes backyard birdfeeders. The company sells the birdfeeders to home 4 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 cell references and formulas where appropriate to receive full credit. If you copy/paste 18 from the Instruction tab you will be marked wrong. 19 20 Requirements Prepare the sales budget, including a separate section that details the type of sales made (cash versus credit) for the first three months of the year, as well as a summary budget for the quarter 2 Prepare the production budget for the first three months of the year, as well as a summary budget INSTRUCTIONS SALESDATA ENTERANSWERS Type here to search Copy of Jenkins_bm05_09_990_start - Excel File Home Insert Draw Page Layout Formulas Data Review View Developer Help Search General B I U .B. A. Merge & Center - $. % ** 20 Requirements 22 Prepare the sales budget, including a separate section that details the type of sales made cash versus credit for the first three months of the year, as well as a summary budget for the quarter, 2. Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be Subtracted 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 Enter amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be Subtracted b. Abbreviation used: OM Direct materials 4 Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter 5 Prepare the cash payments budget for direct material purchases for the month of January February, and March, as well as a summary for the first quarter. 26 27 28 30 Saving & Submitting Solution 31 Savele to desktop 32 Create folder on desktop, and label COMPLETED EXCEL PROJECTS 1 2 Upload and submit your file to be graded 34 Navigate back to the activity window screen where you downloaded the initial spreadsheet 35 b Choose button under step locate the fle you ust u nde Open INSTRUCTIONS S ATA ENTERANSWERS Type here to search Copy of Jenkins_bmas98_58a_start Developer Help Search File Home Insert Draw Page Layout Formulas Data Review View = General Calibri B I - 11 . A A . A E B Wrap Text Merge & Center U . E $ - % 9 4 room Clipboard Alignment Number : 1 x fc The company's collection history indicates that 1 "DATA SHEET -- DO NOT ENTER ANSWERS HERE** 4 October actual sales (prior year) 5 November actual sales (prior year) 6 December actual sales (prior year) 7 January projected sales 8 February projected sales 9 March projected sales 10 April projected sales Units 92,000 85,000 78,000 80,000 90,000 95,000 105,000 12 20% of the total sales are cash sales 80% of the total sales are credit sales 14 The company's collection history indicates that: 15 80% of credit sales is collected in the month after the sale 16 10% is collected two months after the sale 17 6% is collected three months after the sale 18 4% is never collected SENAS INSTRUCTIONS SALESDATA ENTERANSWERS 3 Type here to search Copy of Jenkins 8.5 start cel Formatting Table Soyles. 1. Prepare the sales budget, including a separate section that details the type of sales made cash versus credit for the first three months of the year, as well as a summary budget for the quarter LAW se cell references and formulas where appropriate to receive full credit. if you copy/paste from the instruction tab You will be marked wrong) Birdfeeders Unlimited Sales Budget For the Quarter Ended March 31 Month February March 90000 95.000 1st Quarter 30,000 9 Unit sales breeders) 1 Multiply by: Selling price per birdfeeder 11 Total sales revenue 12 Type of sale: 13 Cash sales 14 Credit sales 15 Total sales revenue $16.000 $64.000 $80,000 $18,000 572.000 $90.000 $19.000 $76,000 595,000 53.000 $212,000 $265.000 12. Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter. Always use cererences and formulas where porte to receive full credit Ule cerferences from requirement1 18 and prior calculations, if applicable. If you coa ste from the instruction to you will be marked wome) Birdfeeders Unlimited Production Budget CHONS SALISBATA INTERANSWERS T here to search TWE RT Y u Caps SD DFG X c V B . N Excel Copy of Jenkins,bma5_pg_5a_start Developer Help Search File Home Insert D Page Layout Formas De Review View Currency BI A E Merge Center $ % Formatting Table Styles 17 2. Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter, Always use cell references and formulas where appropriate to receive full credit. Use cell references from requirement1 18 and prior calculations, if applicable. If you copy/paste from the instruction tab you will be marked wrong) Birdfeeders Unlimited Production Budget For the Quarter Ended March 31 Month February March January 1st Quarter 25 Unitsales (idfeeders) 26 Plus: Desired ending inventory 27 Total needed 26 Less: beginning inventory 29 Number of units to produce 3. Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for 31 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 12 requirements and calculations, if applicatie. If you copy/paste from the Instruction tab you will be marked wrong Birdfeeders Unlimited Direct Materials useet INSTRUCTIONS SALISDATA ENTERANSWERS + QWERTY ASDF Autor Re Home H . InvertDrawPage Layout Copy of Jenkins bas_995, art. Escal Developer Help Search Format Data Review View 3. Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for 11 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 references from prior requirements and calculations applicable. If you coast from the instruction to you will be marked wrong) Bilder Umited Direct Material Budget For the Quarter Ended March 31 Month February March 1st Quarter 39 Units bedfeeders to be produced 40 Multiply by: Quantity board feet) of OM needed per unit 41 Quantity board feet) needed for production 2 Plus Desired and entry of OM 4 Total Quantity board e n ded Les Ben DM S to purchase 5 MobyGoteboard foot Totalco Mpurchases 49 4. Prepare the cash collections budget for lanuary February, and March, as well as a summary for the first quarter Always use cell references and formulas where w ere to receivel credit. Use creerences from previous the incom QWER S DF mas. Eucal Copy ole Developer le Homenat D ageutformas Die Review View s 49 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 50 calculations and requirements, if applicable. If you copy/paste from the instruction tab you will be marked wrong Birdfeeders Unlimited Cash Collections Budget For the Quarter Ended March 31 January February March Quarter Cocoon credite 5 Co o th Credit sales made two months ago 51 Geotes made the month Totalcach collections 5. Prepare the cash payment budget for direct material purchases for the month of January February and March 4 well as a summary for the first quarter Always use c reerences and formulas where appropriate to receive full credit Use c reerences from previous es calculations and requirements, applicable. If you copy/paste from the Instruction tab you will be marked wrone Bin ders Unlimited Cash Payments for Direct Materials Purchases LSDATA INTERNES WE R LAS DF H Capela Z Z X CV BN well as a w a y for the first quarter Anand where calculations and you cobrom the city were wrong er Und Cash Payments for Direct Materials Purchases For the Quarter Ended March 12 Total cost of M urchases 13 Chants for current month purchases Cash payments for prior month purchase 15 Total cash payments Type here to search WE SDF