Prepare a cash payments budget for selling

Assignment Help Managerial Accounting
Reference no: EM132868547

Question - Franklin Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to Prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks.

Required -

October sales are estimated to be $180,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.

The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.

The cost of goods sold is 60 percent of sales. The company desires to maintain a minimum ending inventory equal to 10 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,600. Assume that all purchases are made on account. Prepare an inventory purchases budget.

The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the following month. Prepare a cash payments budget for inventory purchases.

Budgeted selling and administrative expenses per month follow.

Salary expense (fixed) $18,600

Sales commissions 4% of Sales

Supplies expense 2% of Sales

Utilities (fixed) $2,000

Depreciation on store fixtures (fixed)* $4,600

Rent (fixed) $5,400

Miscellaneous (fixed) $1,800

*The capital expenditures budget indicates that Franklin will spend $191,600 on October 1 for store fixtures, which are expected to have a $26,000 salvage value and a three-year (36-month) useful life.

Use this information to prepare a selling and administrative expenses budget.

-Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.

-Franklin borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $18,000 cash cushion. Prepare a cash budget.

Reference no: EM132868547

Questions Cloud

Compliance risk predictable and manageable in crisis : In the 2019 Boeing 737max crisis, the Federal Aviation Administration(FAA) is partially responsible for the crisis due to regulatory failures, so was this compl
Describe brand image goals : Describe your brand image goals in 1-2 short paragraphs. Include at least two qualities that you want people to associate with your brand.
Define the long-run aggregate supply curve : Define the long-run aggregate supply curve? Is there any relationship between the production-possibilities (p-p) curve and its long-run aggregate supply curve (
What is facilitated application specification technique : What are the Functional Requirements for the Product Online Food Ordering System - Write use-cases for the given product requirements
Prepare a cash payments budget for selling : Utilities and sales commissions are paid the month after they are incurred; Prepare a cash payments budget for selling and administrative expenses
Define strategic control : Define strategic control. Differentiate the strategic control mechanisms according to purpose and approach.
Highlights of iot benefits and risks : After viewing our guest speaker's presentation and reading the highlights of "IoT Benefits and Risks" in the Instructor Guidance
List four primary ways additional needs are identified : List four primary ways additional needs are identified?
How much should you pay for one share : If the expected growth rate for dividends is 3.4% per year. How much should you pay for one share if your desired rate of return is 6.6% per year

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd