Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate perfumery business that upholds a high aesthetic value, coaxes excellence, and exudes exclusivity, and provides a product range of natural, alcohol-free, and skin-friendly perfumes. In addition to using organic lavender oil as its main raw material, other ingredients are used, such as flowers, fruits, plant materials, musk, and other natural ingredients. Recently, you have been hired by Macy's Inc. as a new management accountant to assist with creating the budget for the company's fragrance product. In the past, the company hasn't done much in the way of budgeting and at specific times of the year, there's been a cash shortfall. In order to prepare a Master Budget for the second quarter, you have been assembled data mentioned the following balances below as of March 31: (b) Actual sales units for the first quarter and budgeted sales units for the following four months are as follows: Additional Information: . Cash Accounts Receivable Accounts Payable Equipment Common Stock Land Retained Earning . . January (Actual February (Actual) March (Actual) April (Budgeted) May (Budgeted) June (Budgeted) July (Budgeted) August (Budgeted) $380,000 $ 420,000 $ 74,000 $175,000 $ 100,000 $1,564,196 $ 50,000 15000 20000 24000 40000 52000 50000 48000 46000 Each unit is being sold for $30. All sales are on credit. Macy's Inc. collects 60% of sales in the month of the sale and 30% in the month after the sale and remaining in the second following month's sales. Bad debts have been negligible. According to management, Macy's Inc.'s ending inventory should equal 20% of the anticipated unit sales for the upcoming month. It is assumed that 24000 units were available inventory as of March 31. Eight grams of organic lavender oil are required per unit of product. Management wants materials on hand at the end of each month equal to 20% of the following month's production. On March 1 Units Units Units Units Units Units Units Units 31, 42000 grams of material in hand. Macy's Inc pays $0.60 as material cost per gram. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month that follows the purchase. First quarter accounts payable are fully paid in the month of April. Macy's requires an hour of direct labor for every unit of a product and the company pays $14 per hour. At Macy's, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $5 per direct labor hour. Fixed manufacturing overhead is $50,000 per month, which includes $20,000 of noncash costs (primarily depreciation of plant assets). The selling and administrative expense budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.90 per unit sold. Fixed selling and administrative expenses are $70,000 per month. The fixed selling and administrative expenses include $10,000 in costs primarily depreciation that are not cash outflows of the current month. 4. Schedule of expected cash collections. 5. Production Budget 6. Direct Materials Budget Assume that as of April 1, Macy's has a balance of $380,000 in cash and the company need to maintain minimum $500,000 balance at month's end. In case company has shortage of cash, can borrow from the bank and current bank interest rate is 10% per annum. It is assumed that the beginning day of the month would be the day for borrowing, and the last day of the month would be the day for paying back loans. A cash dividend of $32,000 is distributed in April by Macy's Inc and new equipment purchases worth $140,660, paid cash in the month of June. 7. Expected Cash Disbursement for Materials. 8. Direct Labor Budget Required: Using the data above, prepare the following budgets and statements for the second quarter: 1. Budget launch page (Content Page) 2. Beginning balance budget and Budgeting assumptions 3. Sales Budget 9. Manufacturing Overhead Budget 10. Selling And Administrative Expense Budget 11. Cash Budget 12. Prepare a budgeted income statement for the second quarter ending June 30 13. Prepare a budgeted balance sheet as of June 30 Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate perfumery business that upholds a high aesthetic value, coaxes excellence, and exudes exclusivity, and provides a product range of natural, alcohol-free, and skin-friendly perfumes. In addition to using organic lavender oil as its main raw material, other ingredients are used, such as flowers, fruits, plant materials, musk, and other natural ingredients. Recently, you have been hired by Macy's Inc. as a new management accountant to assist with creating the budget for the company's fragrance product. In the past, the company hasn't done much in the way of budgeting and at specific times of the year, there's been a cash shortfall. In order to prepare a Master Budget for the second quarter, you have been assembled data mentioned the following balances below as of March 31: (b) Actual sales units for the first quarter and budgeted sales units for the following four months are as follows: Additional Information: . Cash Accounts Receivable Accounts Payable Equipment Common Stock Land Retained Earning . . January (Actual February (Actual) March (Actual) April (Budgeted) May (Budgeted) June (Budgeted) July (Budgeted) August (Budgeted) $380,000 $ 420,000 $ 74,000 $175,000 $ 100,000 $1,564,196 $ 50,000 15000 20000 24000 40000 52000 50000 48000 46000 Each unit is being sold for $30. All sales are on credit. Macy's Inc. collects 60% of sales in the month of the sale and 30% in the month after the sale and remaining in the second following month's sales. Bad debts have been negligible. According to management, Macy's Inc.'s ending inventory should equal 20% of the anticipated unit sales for the upcoming month. It is assumed that 24000 units were available inventory as of March 31. Eight grams of organic lavender oil are required per unit of product. Management wants materials on hand at the end of each month equal to 20% of the following month's production. On March 1 Units Units Units Units Units Units Units Units 31, 42000 grams of material in hand. Macy's Inc pays $0.60 as material cost per gram. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month that follows the purchase. First quarter accounts payable are fully paid in the month of April. Macy's requires an hour of direct labor for every unit of a product and the company pays $14 per hour. At Macy's, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $5 per direct labor hour. Fixed manufacturing overhead is $50,000 per month, which includes $20,000 of noncash costs (primarily depreciation of plant assets). The selling and administrative expense budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.90 per unit sold. Fixed selling and administrative expenses are $70,000 per month. The fixed selling and administrative expenses include $10,000 in costs primarily depreciation that are not cash outflows of the current month. 4. Schedule of expected cash collections. 5. Production Budget 6. Direct Materials Budget Assume that as of April 1, Macy's has a balance of $380,000 in cash and the company need to maintain minimum $500,000 balance at month's end. In case company has shortage of cash, can borrow from the bank and current bank interest rate is 10% per annum. It is assumed that the beginning day of the month would be the day for borrowing, and the last day of the month would be the day for paying back loans. A cash dividend of $32,000 is distributed in April by Macy's Inc and new equipment purchases worth $140,660, paid cash in the month of June. 7. Expected Cash Disbursement for Materials. 8. Direct Labor Budget Required: Using the data above, prepare the following budgets and statements for the second quarter: 1. Budget launch page (Content Page) 2. Beginning balance budget and Budgeting assumptions 3. Sales Budget 9. Manufacturing Overhead Budget 10. Selling And Administrative Expense Budget 11. Cash Budget 12. Prepare a budgeted income statement for the second quarter ending June 30 13. Prepare a budgeted balance sheet as of June 30
Expert Answer:
Answer rating: 100% (QA)
Budget Launch Page Macys Inc Master Budgets for the Second Quarter This report contains the master budgets for Macys Inc for the second quarter of the year consisting of the months of April May and Ju... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
LLJ Satellites: Variance Analysis and Budgeting Jack Childs is nervous about his company's future performance. The Childs family own 40% of the shares of LLJ Satellites, and generally has control...
-
As a recent graduate, you have been hired by Canadian Communications Inc. (CCI), a large industry leader in the Canadian telecommunications market. CCI is contemplating investing in an upgraded...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
If the resultant force acting on the hook is F R = {? 200i + 800j + 150k} lb, determine the magnitude and coordinate direction angles of F. 30 F= 600 ib
-
A valence electron in a sodium atom is in the state with principal quantum number n = 3, with the total angular momentum being the greatest possible, what is its magnetic moment in that state?
-
A RACI chart is a type of _______________. A. project organizational chart B. resource histogram C. responsibility assignment matrix D. project dashboard
-
Robert Ryan practiced accounting with a partnership for five years. Recently he opened his own accounting firm, which he operates as a professional corporation. The name of the new entity is Robert...
-
The Delmar Beverage Co. produces a premium root beer that is sold throughout its chain of restaurants in the Midwest. The company is currently producing 4,000 gallons of root beer per day, which...
-
Question 6 [6] The three-year zero rate is 8% and the four-year zero rate is 8.8% (both continuously compounded). 6.1 6.2 Determine the forward rate for the fourth year. Explain how a forward rate...
-
The Fashion Rack is a retail merchandising business that sells brand-name clothing at discount prices. The firm is owned and managed by Teresa Lojay, who started the business on April 1, 20X1. This...
-
In automobile mileage and gasoline-consumption testing, 13 automobiles were road tested for 300 miles in both city and highway driving conditions. The following data were recorded for...
-
A company produces and sells one product and provides the following information for the month of June: Budgeted sales: 5 , 5 0 0 units Budgeted production: 5 , 9 0 0 units Budgeted variable selling...
-
Determine the cost of the ending work in process inventory for the Mixing Department for materials, labor, overhead, and total for May. Also, calculate the cost of the completed units transferred to...
-
How do organization/management theorists define behavior and differentiate between inherited and operant behaviors?
-
A 2000-lb wheel load is to be supported by aggregate over soil with a maximum bearing pressure of 1000 lb/sqft. What depth of aggregate is needed if the angle theta is 40 degrees?
-
Nicole, a college student, feels that now is a good time to buy stocks. However, because she doesn't have any savings, she decides to borrow $ 1 5 , 0 0 0 at an annual interest rate of 8 percent. She...
-
Explain how a law firm goes about getting the information it needs to prepare a complaint.
-
Nitrogen monoxide reacts with hydrogen as follows: 2NO(g)+ H2(g) N2O(g) + H2O(g) The rate law is [H2]/ t = k[NO]2[H2], where k is 1.10 107 L2/(mol2s) at 826oC. A vessel contains NO and H2 at...
-
Barker Company has a single product called a Zet. The company normally produces and sells 80,000 Zets each year at a selling price of $40 per unit. The company's unit costs at this level of activity...
-
Under what conditions would it be appropriate to us a process costing system?
-
What is a self-imposed budget? What are the major advantages of self-imposed budgets? What caution must be exercised in their use?
-
What is retrograde condensation?
-
Draw the \(P-x-y\) diagram at constant temperature for a maximum boiling azeotrope.
-
What is Raoult's law? How do you explain the deviation from Raoult's law? What are positive and negative deviation of a solution from ideality?
Study smarter with the SolutionInn App