{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":172,"n_cols":7,"rows_kept":172,"merged":[[0,0,0,5],[1,0,1,5],[3,1,4,1],[77,1,77,5],[78,1,78,5],[79,1,79,5],[109,1,109,2],[110,1,110,2],[111,1,111,2],[129,1,129,4],[130,1,130,4],[131,1,131,4],[147,1,147,3],[148,1,148,3],[149,1,149,3]]}
[]
["KIRA KRAFT CASE"]
[]
[null,"NAMES OF GROUP MEMBERS"]
[]
[]
[]
[null,"SALES BUDGET","OCT.","NOV.","DEC.","TOTAL"]
[null,"UNITS X"]
[null,"Sales Price"]
[null,"Revenues"]
[]
[]
[null,"AR COLLECTIONS","OCT.","NOV.","DEC.","TOTAL"]
[null,"SEPT"]
[null,"OCT"]
[null,"NOV "]
[null,"DEC "]
[null,"TOTALS"]
[]
[]
[null,"AR BALANCE AS OF 12/31="]
[]
[]
[null,"PRODUCTION BUDGET","OCT.","NOV.","DEC.","TOTAL","JAN."]
[null,"SALES"]
[null,"ENDING INVENTORY"]
[null,"BEGINNING INVENTORY"]
[null,"PRODUCTION"]
[]
[]
[]
[null,"PURCHASES BUDGET","OCT.","NOV.","DEC.","TOTAL","JAN."]
[null,"PRODUCTION"]
[null,"*DM/UNIT"]
[null,"KITS"]
[null,"ENDING INVENTORY"]
[null,"BEGINNING INVENTORY"]
[null,"PURCHASES"]
[null,"COST/KIT"]
[null,"$/COST"]
[]
[null,"PAYMENT OF AP","OCT.","NOV.","DEC.","TOTAL"]
[null,"SEPT"]
[null,"OCT"]
[null,"NOV"]
[null,"DEC"]
[null,"TOTALS"]
[]
[null,"A/P 12/31 Balance"]
[]
[null,"DIRECT LABOR BUDGET","OCT.","NOV.","DEC.","TOTAL"]
[null,"PRODUCTION"]
[null,"DLH/UNIT"]
[null,"TOTAL DLH"]
[null,"DLH RATE"]
[null,"DLH COST"]
[]
[null,"AP 12/31 Balance "]
[]
[]
[null,"VOH BUDGET","OCT.","NOV.","DEC.","TOTAL"]
[null,"PRODUCTION"]
[null,"VOH/UNIT"]
[null,"TOTAL HOURS"]
[null,"VOH RATE"]
[null,"TOTAL COST"]
[]
[]
[null,"FOH BUDGET","OCT.","NOV.","DEC.","TOTAL"]
[null,"SALARIES"]
[null,"DEPRECIATION"]
[null,"INSURANCE"]
[null,"UTILITIES"]
[null,"TOTAL COST"]
[]
[]
[null,"KIRA KRAFT, INC."]
[null,"CASH BUDGET"]
[null,"FOR THE 4TH QUARTER"]
[]
[null,null,"OCT","NOV","DEC ","TOTAL"]
[null,"BEG BALANCE"]
[null,"COLLECTIONS"]
[null,"CASH AVAILABLE"]
[null,"DISBURSEMENTS:"]
[null,"      PURCHASES"]
[null,"      DIRECT LABOR"]
[null,"      VOH"]
[null,"      FOH (Cash only no accrual)"]
[null,"      SG&A"]
[null,"      EQUIPMENT"]
[null,"            TOTAL"]
[null,"CASH EXCESS"]
[null,"MINIMUM BALANCE"]
[null,"CASH AVAILABLE"]
[null,"REPAYMENT OF NP"]
[null,"INVESTMENT"]
[null,"RECEIVE INTEREST"]
[null,"PAYMENT INTEREST"]
[null,"ENDING BALANCE"]
[]
[null,"OTHER PAYMENTS, COLLECTIONS & COST ADJUSTMENTS","OCT.","NOV.","DEC.","TOTAL"]
[null,"EQUIPMENT"]
[null,"ADD: DEPRECIATION"]
[null,"INTEREST EXPENSE"]
[null,"INTEREST RECEIVABLE"]
[null,"SALES & ADMINISTRATIVE"]
[]
[null,"KIRA KRAFT, INC"]
[null,"BUDGETED SCHEDULE OF COGM"]
[null,"FOR THE 4TH QUARTER"]
[]
[null,"BEGINNING WIP"]
[null,"     RAW MATERIAL USED"]
[null,"          BEG RAW MATERIAL"]
[null,"          PURCHASES"]
[null,"               AVAILABLE GOODS"]
[null,"     ENDING RAW MATERIAL"]
[null,"COST OF RM USED"]
[null,"     DIRECT LABOR"]
[null,"     VOH"]
[null,"     FOH"]
[null,"TOTAL MFG COST IN PROCESS"]
[null,"ENDING WIP"]
[null,"COGM"]
[]
[]
[]
[null,"KIRA KRAFT INC."]
[null,"BUDGETED INCOME STATEMENT"]
[null,"FOR THE 4TH QUARTER"]
[]
[null,"SALES"]
[null,"     COGS"]
[null,"          BEG INVENTORY"]
[null,"          COG MFG"]
[null,"          COG AVAIL FOR SALE"]
[null,"          ENDING INVENTORY"]
[null,"     GROSS MARGIN"]
[null,"          SG&A EXPENSE"]
[null,"     OPERATING INCOME"]
[null,"          OTHER INCOME/EXPENSE"]
[null,"           INTEREST EXPENSE"]
[null,"           INTEREST REVENUE"]
[null,"NET INCOME"]
[]
[null,"KIRA KRAFT INC"]
[null,"BUDGETED BALANCE SHEET"]
[null,"FOR THE 4TH QUARTER"]
[]
[null,"CASH"]
[null,"ACCOUNTS RECEIVABLE"]
[null,"RAW MATERIAL INVENTORY"]
[null,"FINISHED GOODS INVENTORY"]
[null,"INVESTMENTS"]
[null,"BUILDING"]
[null,"     ACCUM DEPRECIATION"]
[null,"EQUIPMENT"]
[null,"     ACCUM DEPRECIATION"]
[null,"TOTAL ASSETS"]
[]
[null,"LIABILITIES:"]
[null,"ACCOUNTS PAYABLE"]
[null,"TOTAL LIABILITIES"]
[]
[null,"STOCKHOLDERS EQUITY:"]
[null,"      COMMON STOCK"]
[null,"      PAID IN CAPITAL"]
[null,"      RETAINED EARNINGS"]
[null,"TOTAL STOCKHOLDERS EQUITY"]
[null,"TOTAL LIABILITIES & STOCKHOLDERS EQUITY"]