Aztec Firm sells its product for $170 per unit. Its precise and projected gross sales comply with.UnitsApril (precise)Could (precise)June (budgeted)July (budgeted)August (budgeted)Dollars9,0003,2006,0007,0004,400$1,530,000544,0001,zero20,0001,190,000748,000All gross sales are on credit score. Latest expertise exhibits that 28% of credit score gross sales is collected within the month of the sale, 42% within the month after the sale, 28% within the second month after the sale, and a couple of% proves to be uncollectible. The merchandise buy value is $110 per unit. All purchases are payable inside 14days. Thus, 60% of purchases made in a month is paid in that month and the opposite 40% is paid within the subsequent month. The corporate has a coverage to take care of an ending month-to-month stock of 20% of the subsequent months unit gross sales plus a security inventory of 115 items. The April 30 and Could 31 precise inventorylevels are according to this coverage. Promoting and administrative bills for the 12 months are $1,536,000 and are paid evenly all year long in money.The companys minimal money stability at month-end is $100,000. This minimal is maintained, if essential, by borrowing money from the financial institution. If the stability exceeds $100,000, the corporate repays as a lot of the mortgage as it might with out going beneath the minimal. This sort of mortgage carries an annual 11% rate of interest. On Could 31, the mortgage stability is $48,500, and the companys money stability is $100,000. (Spherical quantities to the closest greenback.)1. Put together a desk that exhibits the computation of money collections of its credit score gross sales (accounts receivable) in every of the months of June and July.AprilMayPercent Collected inJuneJulyAugustAprilMayAmount Collected inJuneJulyAugustCredit gross sales from:AprilMayJuneJulyAugustCredit gross sales from:AprilMayJuneJulyAugust2. Put together a desk that exhibits the computation of budgeted ending inventories (in items) for April, Could, June, and July.AZTEC COMPANYBudgeted Ending InventoryFor April, Could, June and JulyAprilMayJuneJulyAugustNext month’s budgeted salesRatio of stock to future salesBudgeted "base" ending inventorySafety stockBudgeted Ending Inventory3. Put together the merchandise purchases finances for Could, June, and July. Report calculations in items after which present the greenback quantity of purchases foreach month.AZTEC COMPANYMerchandise Purchases BudgetsFor Could, June and JulyAprilMayJuneJulyAugustBudgeted Ending Stock (items)Budgeted unit gross sales for monthRequired items of accessible merchandiseBudgeted starting stock (items)Budgeted purchases (items)Budgeted price per unitBudgeted price of merchandise purchases4. Put together a desk exhibiting the computation of money funds on product purchases for June and July.Money funds on product purchases (for June and July)P.c Paid inMayJuneJulyAugustFrom purchases in:MayJuneJulyAugustTotalMayAmount Paid inJuneJulyAugustFrom purchases in:MayJuneJuly5. Put together a money finances for June and July, together with any mortgage exercise and curiosity expense. Compute the mortgage stability on the finish of every month. (Donot spherical intermediate calculations.)AZTEC COMPANYCash BudgetJune and JulyJuneJulyBeginning money balancecash receipts from customersTotal money availableCash disbursements:Funds on purchasesSelling and administrative expensesInterest expenseother possibility might be right here *** see rightTotal money disbursementsPreliminary money balanceAdditional mortgage (compensation)Ending money stability<================different options1 extra mortgage (compensation)2 money receipts from customers3 curiosity expense4 funds on purchases5 promoting and administrative expensesLoan balanceJuneLoan stability – Starting of monthAdditional mortgage repaymentLoan stability – Finish of monthBlack Diamond Firm produces snow skis. Every ski requires 2 kilos of carbon fiber. The companysmanagement predicts that 5,400 skis and 6,400 kilos of carbon fiber might be in stock on June 30 ofthe present 12 months and that 154,000 skis might be bought through the subsequent (third) quarter. A set of two skis sells for$340. Administration desires to finish the third quarter with three,900 skis and four,400 kilos of carbon fiber ininventory. Carbon fiber will be bought for $19 per pound. Every ski requires zero.5 hours of direct labor at$24 per hour. Variable overhead is utilized on the fee of $12 per direct labor hour. The corporate budgetsfixed overhead of $1,786,000 for the quarter.1. Put together the third-quarter manufacturing finances for skis.Put together the third-quarter manufacturing finances for skis.BLACK DIAMOND COMPANYProduction Finances (in items)Third QuarterBudgeted ending stock (skis)Add budgeted items gross sales for quarterRequired items out there for productionDeduct budgeted starting stock (skis)Models to be manufactured2. Put together the third-quarter direct supplies (carbon fiber) finances; embody the greenback price of purchases.Put together the third-quarter manufacturing finances for skis.BLACK DIAMOND COMPANYDirect Supplies BudgetThird QuarterBudgeted productionother possibility might be right here *** see rightMaterials (carbon fiber) wanted for productionAdd budgeted ending stock (carbon fiber)Complete supplies (carbon fiber) requirementsDeduct budgeted starting stock (carbon fiber)Models of supplies (carbon fiber) to be purchasedMaterials value per poundTotal price of direct supplies purchases<================different options1 budgeted starting inventory2 budgeted ending inventory3 budgeted items gross sales for month4 supplies necessities per unit5 supplies to be purchased6 supplies value per pound
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
