Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st balance sheet (Actual): cash $25,000 accounts payable $62,016 accounts receivable 133,000 inventory 32,813 capital stock 295,372 203,500 (net) b. building and equipment Actual sales for August and budgeted sales for September, October, and November are given below: retained eamings 36,925 August-Actual $190,000 September-Projected 375,000 October-Projected 405,000 November-Projected 310,000 C. d. e. f. B h. Required: Sales are 30% for cash and 70% on credit. All credit sales are collected in the month following the sale. There are no bad debts. The gross margin percentage is 65% of sales. The desired ending inventory is equal to 25% of the following month's COGS. One fourth of the purchases are paid for in the month of the purchase and the remaining 75% are purchased on account and paid in full the following month. The monthly operating expenses are $90,000 including the monthly depreciation of $8,000 In September, Mecca Company will purchase new office equipment for $40,000 cash. The expected useful life of the new equipment is 5 years, with no salvage value. It will be depreciated using the straight-line method. Mecca will start depreciating the equipment in September (full month). Dividends of $23,500 and $30,000 will be declared and paid in September and October, respectively. The company must maintain a minimum cash balance of $32,000 starting September. A line of credit is used to maintain this balance. Borrowing will be made in increments of $1,000. All bomowing is done at the beginning of the month and repayments are made at the end of the month. The annual interest rate is 12%, paid when the loan is repaid (ignore the accrual of interest). 1. Prepare a balance sheet, income statement, and cash budget for the month of September. Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st balance sheet (Actual): cash $25,000 accounts payable $62,016 accounts receivable 133,000 inventory 32,813 capital stock 295,372 203,500 (net) b. building and equipment Actual sales for August and budgeted sales for September, October, and November are given below: retained eamings 36,925 August-Actual $190,000 September-Projected 375,000 October-Projected 405,000 November-Projected 310,000 C. d. e. f. B h. Required: Sales are 30% for cash and 70% on credit. All credit sales are collected in the month following the sale. There are no bad debts. The gross margin percentage is 65% of sales. The desired ending inventory is equal to 25% of the following month's COGS. One fourth of the purchases are paid for in the month of the purchase and the remaining 75% are purchased on account and paid in full the following month. The monthly operating expenses are $90,000 including the monthly depreciation of $8,000 In September, Mecca Company will purchase new office equipment for $40,000 cash. The expected useful life of the new equipment is 5 years, with no salvage value. It will be depreciated using the straight-line method. Mecca will start depreciating the equipment in September (full month). Dividends of $23,500 and $30,000 will be declared and paid in September and October, respectively. The company must maintain a minimum cash balance of $32,000 starting September. A line of credit is used to maintain this balance. Borrowing will be made in increments of $1,000. All bomowing is done at the beginning of the month and repayments are made at the end of the month. The annual interest rate is 12%, paid when the loan is repaid (ignore the accrual of interest). 1. Prepare a balance sheet, income statement, and cash budget for the month of September.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
Macheski Company, an importer and retailer of Polish pottery and kitchenware, prepares a monthly master budget. Data for the July master budget are given below: The June 30th balance sheet follows...
-
1. List five line coding schemes discussed in this book. 2. Define block coding and give its purpose. 3. Define scrambling and give its purpose. 4. Compare and contrast PCM and DM 5. What are the...
-
Use integration by partial fractions to compute the following indefinite integrals. dx x(2 +3x)
-
In Problem find the vertex form for each quadratic function. Then find each of the following: (A) Intercepts (B) Vertex (C) Maximum or minimum (D) Range f(x) = x 2 - 8x + 12
-
A healthcare home-care firm has a profit margin of 15 percent on visiting nurse sales of $\$ 20,000,000$. If the firm has debt of $\$ 7,500,000$, total assets of $\$ 22,500,000$, and an after-tax...
-
Suppose you are a monopolist and you have two customers, Joseph and Monique. Each will buy either zero or one unit of the good you produce. Joseph is willing to pay up to $50 for your product;...
-
(13%) Problem 4: A student standing on a cliff throws a stone from a vertical height of d = 8.0 m above the level ground with velocity vo = 18 m/s at an angle 0 = 32 below the horizontal, as shown....
-
John works at a bakery in New York City. He is the only employee who makes chocolate cakes (and he only needs to make the cakes). On average, it takes him 30 minutes to make a cake. The average...
-
A water stream contacts a bed of particles, which have diameters ranging from 1 to $1000 \mu \mathrm{m}$ and $S G=2.5$. The water stream flows upward at a rate of $3 \mathrm{~cm} / \mathrm{s}$. What...
-
A settling tank contains solid particles that have a wide range of sizes. Water is pumped into the tank from the bottom and overflows on top at a rate of $10,000 \mathrm{gal} / \mathrm{h}$. If the...
-
A hot dog at \(5^{\circ} \mathrm{C}\) is to be cooked by dipping it in boiling water at \(100^{\circ} \mathrm{C}\). Model the hot dog as a long cylinder with a diameter of \(20 \mathrm{~mm}\). Find...
-
A concrete wall \(20 \mathrm{~cm}\) thick is initially at a temperature of \(20^{\circ} \mathrm{C}\), and is exposed to steam at pressure \(1 \mathrm{~atm}\) on both sides. Find the time for the...
-
2. Use the information in Tables 2.5 and 2.6 with the additional information and complete the Purcell Diagram in Figure 2.3. The additional information given is for calculating some of the adjustment...
-
1. Cars arrive at a car wash fandomly and independently; the probability of an arrival is the same for any two time intervals of equal length. The mean arrival rate is 15 cars per hour. what is the...
-
An item of depreciable machinery was acquired on 1 July 2009 for $120,000 by cash It is expected to have a useful life of 10 years and zero salvage value On 1 July 2012, it was decided to revalue the...
-
The assessment center approach to employee selection relies heavily on ____________ to evaluate a candidates job skills. (a) intelligence tests (b) simulations and experiential exercises (c) 360...
-
The selection technique known as ______________ asks a job candidate to actually perform on the job for a period of time while being observed by a recruiter. (a) mentoring (b) work sampling (c) job...
-
What is one of the reasons why employers are hiring more part-time or contingency workers? (a) Its hard to get people to work full-time anymore. (b) Part-timers are known to work much harder than...
Study smarter with the SolutionInn App