116 X V A B C D E F G H MASTER BUDGET AND CASH BUDGET FINAL EXAM 2 3 BABYENA Company is preparing budgets for the quarter ending June 30. 5 Budgeted sales APRIL MAY JUNE TOTAL 6 APRIL 10,000.00 BUDGETED SALES 7 MAY 40,000.00 SP PER UNIT 8 JUNE 35,000.00 TOTAL BUDGETED SALES 9 JULY 20,000.00 10 AUGUST 20,000.00 11 THE SELLING PRICE IS AT 15 PER UNIT EXPECTED CASH COLLECTIONS 12 APRIL MAY JUNE TOTAL 13 ADDITIONAL INFO ACCOUNTS RECEIVABLE MARCH 14 ALL SALES ARE ON ACCOUNT APRIL SALES 15 LIGAYA'S COLLECTION PATTER IS: 70% 16 65% IN THE MONTH OF SALE, 30% IN THE MONTH FOLLOWING THE SALE 25% 17 5% UNCOLLECTIBLE MAY SALES 18 MARCH 31 ACCOUNTS RECEIVABLE IS 25,000 70% 19 25% 20 JUNE SALES 21 70% TATAL FALLRATIONS n Sheet1 Sheet2 Sheet3 example take home exam (+) Ready Accessibility: Investigate + 100%.'1. El ' MASTER BUDGET AND CASH BUDGET FINAL EXAM -BABYENA Company is preparing budgets for the quarter ending June 30. REPAYMENTS INTEREST TOTAL FINANCING END CASH BALANCE BlJDGETED INCOME STATEMENT SALES COGS (100,000 x 4.99) GM SELLING ADMIN OPERATING INCOME INTEREST EXPENSE NET INCOME SALES BUDGET ADD INFORMATION [SALES BUDGET X 5] SA BUDGET 1 D: 39 P M 6/ 234' 202.1 1. E: MASTER BUDGET AND CASH BUDGET FINAL EXAM BABYENA Company is pteparing budgets for the quarter ending June 30. THE MANAGEMENT AT LIGAYA COMPANY WANTS ENDING INVENTORY AT 20% OF THE FOLLOWING MONTH'S SALES IN UNITS. MARCH 31 INVENTORY AT 5,000 UNITS LIGAYA COMPANY, 5 POUNDS OF MATERIAL ARE REQUIRED PER UNIT LIGAYA WANTS MATERIALS ON HAND ENDING EQUAL TO 10% OF THE FOLLOWING MONTHS PRODUCTION ON MARCH 31, 13,000 POUNDS OF MATERIAL ARE ON HAND MATERIAL COST IS .40 PER POUND. like home exam JUNE SALES TOTAL COLLECTIONS PRODUCTION BUDGETED SALES IN UNITS ADD: DESIRED El TOTAL NE EDS LESS: BEGINNING INVENTORY REQUIRED PRODUCTION MATERIALS BU DG ET PRODUCTION MATERIALS PER UNIT [POUNDS] PRODUCTION NEEDS ADD: DESIRED ENDING INVEMTORY TOTAL NEEDED (+3 :1. E MASTER BUDGET AND CASH BUDGET FINAL EXAM BABYENA Company is pteparing budgets for the quartet ending June 30. LIGAYA COMPANY, 5 POUNDS OF MATERIAL ARE REQUIRED PER UNIT LIGAYA WANTS MATERIALS ON HAND ENDING EQUAL TO 10% OF THE FOLLOWING MONTHS PRODUCTION ON MARCH 31, 13,000 POUNDS OF MATERIAL ARE ON HAND MATERIAL COST IS .40 PER POUND. LIGAYA PAYS .40 PER POUND OF MATERIALS 1f2 OF MONTHS'S PURCHASES IS PAID IN THE MONTH OF PURCHASE 1f2 REMAINING WILL BE PAID FOLLOWING MONTH " MARCH 31 ACCOUNTS PAYABLE AT 12,000 NOTE: MATERIALS TO BE PURCHASED X POUNDS X 50% like home exam MATERIALS BUDGET PRODUCTION MATERIALS PER UNIT [POUNDS] PRODUCTION NEEDS ADD: DESIRED ENDING INVEMTORY TOTAL NEEDED LESS: BEGINNING INVENTORY MATERIALS TO BE PURCHASED EXPECTED CASH DISBU RSEMENT ACCO U NTSPA'I'ABLE MAR CH APRIL PURCHASES MAY PU R CHASES 116 X V B C D E F G H MASTER BUDGET AND CASH BUDGET FINAL EXAM 2 3 BABYENA Company is preparing budgets for the quarter ending June 30. 39 1/2 OF MONTHS'S PURCHASES IS PAID IN THE MONTH OF PURCHASE EXPECTED CASH DISBURSEMENT 40 1/2 REMAINING WILL BE PAID FOLLOWING MONTH 41 MARCH 31 ACCOUNTS PAYABLE AT 12,000 APRIL MAY JUNE TOTAL 42 ACCOUNTSPAYABLE MARCH 43 NOTE: MATERIALS TO BE PURCHASED X POUNDS X 50% APRIL PURCHASES 44 50% 45 50% 46 MAY PURCHASES 47 48 49 JUNE PURCHASES 50 51 TOTAL materials disbursement 52 53 DL BUDGET 54 EACH UNIT OF PRODUCT REQUIRES 0.03 OF DIRECT LABOR APRIL MAY JUNE TOTAL 55 RATE 10 PER HOUR UNITS OF PRODUCTION 56 MINIMUM PAYMENT 2000 HOURS PER MONTH DL PER UNIT Sheet1 Sheet2 Sheet3 example take home exam + Ready Accessibility: Investigate + 100% X P Ps W T N O 10:37 PM116 X V B C D E F G H MASTER BUDGET AND CASH BUDGET FINAL EXAM 2 3 BABYENA Company is preparing budgets for the quarter ending June 30. 51 TOTAL materials disbursement 52 53 DL BUDGET 54 EACH UNIT OF PRODUCT REQUIRES 0.03 OF DIRECT LABOR APRIL MAY JUNE TOTAL 55 RATE 10 PER HOUR UNITS OF PRODUCTION 56 MINIMUM PAYMENT 2000 HOURS PER MONTH DL PER UNIT 57 LABOR HOURS REQUIRED 58 GUARANTEED HOURS 59 LABOR HOURS PAID 60 HOURLY RATE 61 MOH IS APPLIED TO UNITS OF PRODUCT ON THE BASIS OF DL HOURS TOTAL DIRECT LABOR COSTS 0 0 0 62 VARIABLE MOH IS 20 PER DL HOUR 63 FIXED MOH IS 40,000 PER MONTH (INCLUDES 20,000 NON CASH COST) MOH BUDGET 64 APRIL MAY JUNE TOTAL 65 BUDGETED DLH 66 VARIABLEOH RATE 67 VARIABLE SELLING AND ADMIN 0.50 PER UNIT SOLD VARIABLE COSTS 68 FSA 50,000 PER MONTH (INCLUDES 10,000 DEPRECIATION) FIXED COSTS TOTAL MALL FACTO Sheet1 Sheet2 Sheet3 example take home exam + Ready TX Accessibility: Investigate + 100% X Ps W O N O TX X 10:37 PM 6/22/2022116 X V B C D E F G H MASTER BUDGET AND CASH BUDGET FINAL EXAM 2 3 BABYENA Company is preparing budgets for the quarter ending June 30. 57 LABOR HOURS REQUIRED 58 GUARANTEED HOURS 59 LABOR HOURS PAID HOURLY RATE 61 MOH IS APPLIED TO UNITS OF PRODUCT ON THE BASIS OF DL HOURS TOTAL DIRECT LABOR COSTS 0 0 0 62 VARIABLE MOH IS 20 PER DL HOUR 63 FIXED MOH IS 40,000 PER MONTH (INCLUDES 20,000 NON CASH COST) MOH BUDGET 64 APRIL MAY JUNE TOTAL 65 BUDGETED DLH 66 VARIABLEOH RATE 67 VARIABLE SELLING AND ADMIN 0.50 PER UNIT SOLD VARIABLE COSTS 68 FSA 50,000 PER MONTH (INCLUDES 10,000 DEPRECIATION) FIXED COSTS 69 TOTAL MOH COSTS 70 LESS: NON CASH EXP 71 CASH DISBURSEMENT FOR MOH 0 0 0 72 73 budgeted selling admin APRIL MAY JUNE TOTAL 74 BUDGETED SALES (IN UNITS) LICA Sheet1 Sheet2 Sheet3 example take home exam + Ready Accessibility: Investigate + 100% Ps W O N O 10:38 PM 6/22/2022.'l E: ' _ MASTER BUDGET AND CASH BUDGET FINAL EXAM - BABYENA Company is preparing budgets for the quarter ending June 30. VSA RATE VARIABLE EXPENSES FSA EXPENSES TOTAL SELLING ADMIN LESS: NON CASH CASH SELLING AND ADMIN _MAINTAIN5 10% LINE OF CREDIT FOR 35000 CASH BUDGET _ MAINTAINS MINIMUM CASH BALANCE OF 30.000 _ BORROWS ON THE FIRST DAYr PAY AT END OF THE MONTH _ PAYS CASH DIVIDENDS OF 40,000 IN APRIL BEG CASH 40000 beg cash CREATED ADD: COLLECTIONS _ purchase 130,000 in may and 30,000 forjune EQUIPMENT TOTAL (ASH AVAILABLE LESS: DISBURSEMENT CREATED MATERIAL CREATED CREATED CREATED 1 D: 33 P M 15/511201! 116 X V fx A B C D E F G H MASTER BUDGET AND CASH BUDGET FINAL EXAM 3 BABYENA Company is preparing budgets for the quarter ending June 30. 87 purchase 130,000 in may and 30,000 for june EQUIPMENT TOTAL CASH AVAILABLE 88 LESS: DISBURSEMENT 89 CREATED MATERIAL 90 CREATED DL 91 CREATED MOH 92 CREATED SA 93 EQUIPMENT PURCHASE 94 DIVIDEND 95 ADD: COLLECTIONS 96 EXCESS (DIFICIENCY) 97 FINANCING: 98 BORROWING 99 REPAYMENTS 100 INTEREST 101 TOTAL FINANCING 102 END CASH BALANCE 103 104 BUDGETED INCOME STATEMENT CALre CAIRO DURANT Sheet1 Sheet2 Sheet3 example take home exam + Ready Ex Accessibility: Investigate + 100% Ps W O N O 10:39 PM 6/22/2022