e. Monthly operating expenses for the company are given below: Variable: Sales commissions Fixed: Advertising Rent...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
e. Monthly operating expenses for the company are given below: Variable: Sales commissions Fixed: Advertising Rent 4% of sales Paid as incurred $300,000 28,000 126,000 12,000 2,600 Paid as incurred Paid as incurred Paid as incurred Paid as incurred Salaries Utilities Insurance Depreciation 24,000 Insurance is paid on an annual basis, in November of each year $31,200 was paid on 1 November last year (i.e., 2600 per month). f. The company plans to purchase $21,000 in new equipment during May and $50,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $22,500 each quarter, payable in the first month of the following quarter. b. h. The company maintains a minimum cash balance of $60,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month. The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $60,000 in cash. Required: 1 Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets: a. A sales budget, by month and in total. schedule of expected cash collections from sales, by month and in total. e. Monthly operating expenses for the company are given below: Variable: Sales commissions Fixed: Advertising Rent 4% of sales Paid as incurred $300,000 28,000 126,000 12,000 2,600 Paid as incurred Paid as incurred Paid as incurred Paid as incurred Salaries Utilities Insurance Depreciation 24,000 Insurance is paid on an annual basis, in November of each year $31,200 was paid on 1 November last year (i.e., 2600 per month). f. The company plans to purchase $21,000 in new equipment during May and $50,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $22,500 each quarter, payable in the first month of the following quarter. b. h. The company maintains a minimum cash balance of $60,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month. The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $60,000 in cash. Required: 1 Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets: a. A sales budget, by month and in total. schedule of expected cash collections from sales, by month and in total.
Expert Answer:
Related Book For
Introduction to Probability and Statistics
ISBN: 978-1133103752
14th edition
Authors: William Mendenhall, Robert Beaver, Barbara Beaver
Posted Date:
Students also viewed these accounting questions
-
An engineer collected monthly operating expenses for the past 3 years for a micro-finishing department. Use the midpoints of each range in preparing your answers. (a) Develop a plot of the...
-
A random sampling of a company's monthly operating expenses for n = 36 months produced a sample mean of $5474 and a standard deviation of $764. Find a 90% upper confidence bound for the company's...
-
Annual purchasing salaries are $65,000, operating expenses for the purchasing department are $25,000, and inspecting and receiving costs are $25 per order. If the purchasing department places 9000...
-
Given the functions f(x) = 2x and g(x) = x 1) Find the points of intersection of the curves and plot the graphs of the functions. 2) Determine the area bounded by the curves in the interval [-1,3] 3)...
-
a. Explain how Jackies uses its LRAC curve to decide how many canoes to rent. b. Does Jackies production function feature economies of scale or diseconomies of scale? The table shows the production...
-
(a) What is the name of the defect of vision in which an eye can see nearby objects clearly but not distant ones? (b) What is the name of the defect of vision in which either bar of a cross can be...
-
3. BYSTANDER RULE The common law bystander rule holds that, generally, no one has a duty to assist someone in peril unless the bystander himself created the danger. Courts have carved some exceptions...
-
The marketing department of Metroline Manufacturing estimates that its sales in 2013 will be $1.5 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay...
-
14. Inday is settling the estate of his Filipino husband Nicanor, who died intestate in the Netherlands where he works as an OFW. The following are the summary of the details of Nicanor's properties...
-
The Cascades Swim Club has 300 shareholders, each holding one share of stock in the club. A share of club stock allows the shareholders family to use the clubs heated outdoor pool during the summer...
-
Identify the resources a project manager can add to or change in a project when uncertainties come into play? Explain how being prepared can make these adaptations prevent further complications. What...
-
Why the Fed is doing rate hikes? What is the impact of rate hikes on real economy, such as inflation, employment, rents, mortgages, housing market, etc.? Use SVB as an example. what were SVB's key...
-
After reading the excerpt, describe the following concepts. https://archive.org/details/casablanca.-1942.720.x-264.-yify_202204. Identify the nature or type of power relationship. When available,...
-
What is the NPV of a project that costs $200,000, provides $43,000 in after-tax cash flows (excluding the CCA tax shield) annually for six years , requires a $5,000 increase in net working capital,...
-
What is the order of operations in the following SQL statement (in other words, what goes first)? SELECT RPAD(SUBSTR(JOB_TITLE,1,5),6,'*') FROM JOBS;
-
Being a critical consumer of messages is more important than ever in the increasingly mediated society that we live in. This means being able to analyze all messages for purpose, audience, intended...
-
. Question 2 AM Consultants operates a number of Consultancy firms (Brisbane and Sydney). The following information relates to a number of accounts presented in the Trial Balance of AM Consultants...
-
Show that, given a maximum flow in a network with m edges, a minimum cut of N can be computed in O(m) time.
-
Let x be a hypergeometric random variable with N = 15, n = 3, and M = 4. a. Calculate p(0), p(1), p(2), and p(3). b. Construct the probability histogram for x. c. Use the formulas given in Section...
-
Identify each variable as continuous or discrete: a. Number of people in line at a supermarket checkout counter b. Depth of a snowfall c. Length of time for a driver to respond when faced with an...
-
A random sample of n = 500 observations from a binomial population produced x = 450 successes. Estimate the binomial proportion p and calculate the margin of error.
-
List some tax advantages of retirement investing.
-
Go to the Web site of Yahoo! Finance (http://finance.yahoo.com). Enter the ticker symbol for Home Depot (HD) and Lowes (LOW). For each firm, click on Profile and note the ratio for Profit Margin (the...
-
Describe why you should itemize deductions as opposed to taking the standard deduction.
Study smarter with the SolutionInn App