{"id":78096,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/acct6111_fall-2013_assignment-2_case-1_budgeting_muscat-sandals-company-msc-2"},"modified":"2017-08-18T07:18:20","modified_gmt":"2017-08-18T07:18:20","slug":"acct6111_fall-2013_assignment-2_case-1_budgeting_muscat-sandals-company-msc-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/acct6111_fall-2013_assignment-2_case-1_budgeting_muscat-sandals-company-msc-2\/","title":{"rendered":"ACCT6111_Fall 2013_Assignment 2_Case 1_Budgeting_Muscat Sandals Company (MSC)"},"content":{"rendered":"<p><a class=\"acct6111_fall-2013_assignment-2_case-1_budgeting_muscat-sandals-company-msc-6\/\"><\/a> <\/p>\n<p>ACCT6111 <strong>Fall 2013<\/strong> <strong><span style=\"text-decoration: underline\">Assignment 2<\/span><\/strong><\/p>\n<p><span style=\"text-decoration: underline\">Case 1: Budgeting<\/span><\/p>\n<p>Muscat Sandals Company (MSC) makes a very popular cloth sandal in one style, but in Regular and Deluxe. The Regular sandals have cloth soles and the Deluxe sandals have cloth covered wooden soles. MSC is preparing its budget for January 2013, and has estimated sales based on past experience.<\/p>\n<p>Other information for the month of January follows:<\/p>\n<p><strong><span style=\"text-decoration: underline\">Input Prices<\/span><\/strong><\/p>\n<p>Direct materials<\/p>\n<p>Cloth $3.50 per yard<\/p>\n<p>Wood $5.00 per board foot<\/p>\n<p>Direct manufacturing labor $10 per direct manufacturing labor-hour<\/p>\n<p><strong><span style=\"text-decoration: underline\">Input Quantities per Unit of Output (per pair of sandals<\/span><\/strong><strong>)<\/strong><\/p>\n<p><strong><span style=\"text-decoration: underline\">Regular<\/span><\/strong> <strong><span style=\"text-decoration: underline\">Deluxe<\/span><\/strong><\/p>\n<p>Direct materials<\/p>\n<p>Cloth 1.3 yards 1.5 yards<\/p>\n<p>Wood 0 2 board feet<\/p>\n<p>Direct manufacturing labor-hours (DMLH) 5 Hours 7 Hours<\/p>\n<p>Setup-hours per batch 2 Hours 3 Hours<\/p>\n<p><strong><span style=\"text-decoration: underline\">Inventory Information, Direct Materials<\/span><\/strong><\/p>\n<p><strong>Cloth Wood<\/strong><\/p>\n<p>Beginning inventory 610 yards 800 b.f.<\/p>\n<p>Target ending inventory 386 yards 295 b.f.<\/p>\n<p>Cost of beginning inventory $2,146 $4,040<\/p>\n<p>MSC accounts for direct materials using a FIFO cost flow assumption.<\/p>\n<p><strong><span style=\"text-decoration: underline\">Sales and Inventory Information, Finished Goods<\/span><\/strong><\/p>\n<p><strong><span style=\"text-decoration: underline\">Regular<\/span><\/strong> <strong><span style=\"text-decoration: underline\">Deluxe<\/span><\/strong><\/p>\n<p>Expected sales in units (pairs of sandals) 2,000 3,000<\/p>\n<p>Selling price $80 $130<\/p>\n<p>Target ending inventory in units 400 600<\/p>\n<p>Beginning inventory in units 250 650<\/p>\n<p>Beginning inventory in dollars $15,500 $61,750<\/p>\n<p>MSC uses a FIFO cost flow assumption for finished goods inventory.<\/p>\n<p>All the sandals are made in batches of 50 pairs of sandals. MSC incurs manufacturing overhead costs, marketing and general administration, and shipping costs. Besides materials and labor, manufacturing costs include setup, processing, and inspection costs. MSC ships 40 pairs of sandals per shipment. MSC uses activity-based costing and has classified all overhead costs for the month of January as shown in the following chart:<\/p>\n<p><strong><span style=\"text-decoration: underline\">Cost type<\/span><\/strong><strong> <span style=\"text-decoration: underline\">Denominator Activity<\/span> <span style=\"text-decoration: underline\">Rate<\/span><\/strong><\/p>\n<p><strong>Manufacturing:<\/strong><\/p>\n<p>Setup Setup-hours $12 per setup-hour<\/p>\n<p>Processing Direct manufacturing labor-hours $1.20 per DMLH<\/p>\n<p>Inspection Number of pairs of sandals $0.90 per pair<\/p>\n<p><strong>Nonmanufacturing:<\/strong><\/p>\n<p>Marketing and general administration Sales revenue 8%<\/p>\n<p>Shipping Number of shipments $10 per shipment<\/p>\n<p><strong><span style=\"text-decoration: underline\"><br \/> <\/span><\/strong><strong><span style=\"text-decoration: underline\">Required:<\/span><\/strong><\/p>\n<p>1. Prepare each of the following for January:<\/p>\n<p>a. Revenues budget<\/p>\n<p>b. Production budget in units<\/p>\n<p>c. Direct material usage budget and direct material purchases budget in both units and dollars; round to dollars<\/p>\n<p>d. Direct manufacturing labor cost budget<\/p>\n<p>e. Manufacturing overhead cost budgets for processing and setup activities<\/p>\n<p>f. Budgeted unit cost of ending finished goods inventory and ending inventories budget<\/p>\n<p>g. Cost of goods sold budget<\/p>\n<p>h. Marketing and general administration costs budget<\/p>\n<p>2. MSC\u2019s balance sheet for December 31 follows. Use it and the following information to prepare a cash budget for MSC for January. Round to dollars.<\/p>\n<p>\u2022 All sales are on account; 60% are collected in the month of the sale, 38% are collected the following month, and 2% are never collected and written off as bad debts.<\/p>\n<p>\u2022 All purchases of materials are on account. MSC pays for 80% of purchases in the month of purchase and 20% in the following month.<\/p>\n<p>\u2022 All other costs are paid in the month incurred, including the declaration and payment of a $10,000 cash dividend in January.<\/p>\n<p>\u2022 MSC is making monthly interest payments of 0.5% (6% per year) on a $100,000 long term loan.<\/p>\n<p>\u2022 MSC plans to pay the $7,200 of taxes owed as of December 31 in the month of January. Income tax expense for January is zero.<\/p>\n<p>\u2022 30% of processing and setup costs, and 10% of marketing and general administration costs are depreciation.<\/p>\n<p><strong>Balance Sheet as of December 31<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Assets<\/strong><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Cash<\/td>\n<td><\/td>\n<td>$ 6,290<\/td>\n<\/tr>\n<tr>\n<td>Accounts receivable<\/td>\n<td>$216,000<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Less: Allowance for bad debts<\/td>\n<td>10,800<\/td>\n<td>205,200<\/td>\n<\/tr>\n<tr>\n<td>Inventories<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Direct materials<\/td>\n<td><\/td>\n<td>6,186<\/td>\n<\/tr>\n<tr>\n<td>Finished goods<\/td>\n<td><\/td>\n<td>77,250<\/td>\n<\/tr>\n<tr>\n<td>Fixed assets<\/td>\n<td>$580,000<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Less: Accumulated depreciation<\/td>\n<td>90,890<\/td>\n<td>489,110<\/td>\n<\/tr>\n<tr>\n<td>Total assets<\/td>\n<td><\/td>\n<td>$784,036<\/td>\n<\/tr>\n<tr>\n<td><strong>Liabilities and Equity<\/strong><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Accounts payable<\/td>\n<td><\/td>\n<td>$ <strong>10,400<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Taxes payable<\/td>\n<td><\/td>\n<td>7,200<\/td>\n<\/tr>\n<tr>\n<td>Interest payable<\/td>\n<td><\/td>\n<td>500<\/td>\n<\/tr>\n<tr>\n<td>Long-term debt<\/td>\n<td><\/td>\n<td>100,000<\/td>\n<\/tr>\n<tr>\n<td>Common stock<\/td>\n<td><\/td>\n<td>200,000<\/td>\n<\/tr>\n<tr>\n<td>Retained earnings<\/td>\n<td><\/td>\n<td>465,936<\/td>\n<\/tr>\n<tr>\n<td>Total liabilities and equity<\/td>\n<td><\/td>\n<td>$784,036<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Prepare a budgeted income statement for January and a budgeted balance sheet for MSC as of January 31.<i><\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ACCT6111 Fall 2013 Assignment 2 Case 1: Budgeting Muscat Sandals Company (MSC) makes a very popular cloth sandal in one style, but in Regular and Deluxe. The Regular sandals have cloth soles and the Deluxe sandals have cloth covered wooden <a href=\"https:\/\/www.benedictsol.com\/blogs\/acct6111_fall-2013_assignment-2_case-1_budgeting_muscat-sandals-company-msc-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-78096","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=78096"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78096\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=78096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=78096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=78096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}