Attachment # 00011140 - FIN_615_Week_4_Homework_10.01_.17_.xlsx
FIN_615_Week_4_Homework_10.01_.17_.xlsx (23.1 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Homework Week 4Cash Budgeting and DFNScenario AnalysisBudgeted Sales on Account: Collection Schedule:JuneIn month of saleJulyIn 1st month after saleAugustIn 2nd month after saleSeptemberIn 3rd month after saleOctoberUncollectibleNovemberDecember20X020X1YearS frame unit salesL frame unit salesx L sales priceof current quarter's credit salesof previous quarter's credit salesDirect labor: Direct-labor hours per frame Rate per direct-labor hourManufacturing overhead: Indirect material Indirect labor OtherPayment of dividends CashAccounts payableCommon stockRetained earnings   10,400Week 4Working CapitalThere are two problemsThe first is a collections pattern, where you have to calculate the collections per month using a waterfall technique.The second is a lengthy cash budgeting problem which begins with sales forecasts through material purchases and disbursementsQ4Q1Q2Q3S sales pricePercent of sales made for cash in the quarter of salePercent of sales made on creditDLH atper hourSelling and admin. expensesDepreciationper quarterBalance Sheet as of Dec 21, 20X0Accounts ReceivableInventoryRaw MaterialFinished GoodsPlant and Equipment, netTotal AssetsTotal Liabilities and equityPrepare the followingSales budgetCash receipts budgetCash disbursements budgetSummary cash budgetSales figuresCollectionsLess beginningDirect Material purchasesMetal price/poundMetal (pounds)Glass sheetsTotal glass needed for productionPlus desired ending inventoryGlass purchases(sheets)Cost/sheetPurchasesPredetermined overhead rateper DLHOther expensesof current quarter's purchases paid in the current quarterof previous quarter's purchases paid in the current quarter
Tutorials for this Question
  1. neil2103
    Tutorial # 00595905 Posted By: neil2103 Posted on: 10/01/2017 10:44 PM
    Puchased By: 3
    Tutorial Preview
    The solution of Finance Problem...
      Get the Solution
    Attachments
    week_4.xlsx (31.17 KB)
Whatsapp Lisa