Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I only need M-Q, I figured you'd need the rest tho. Thank you! Dimash Inc.is a recreational outfitter that provides quality products based around fun

I only need M-Q, I figured you'd need the rest tho. Thank you!

Dimash Inc.is a recreational outfitter that provides quality products based around fun and water. The Company is now considering expanding its offerings to include specialty touring kayaks. Kayak By Designconceptgrew out of inspiration and experience of its resident sportsman and craftsman, Dimash Kudaibergen. Long before the paddle enters the water, each Kayak design begins with a pen stroke.With the prototype in hand, the goal now is to open a Kayak Design and Sales Center on January 1, 2021. To make the decision, Dimash planning group requires a master budget for the centers first quarter of operation (i.e., January, February, Marchof 2021).

Requirements: Based on the following estimates, you are asked to construct a three-month master budget for the months of January, February, and March.

a.The Company owners will contribute $50,000 cash to get this center started.

b.Its capital expenditures projection requires that the Company purchased $328,000 of equipment on January 2forthe new center. The equipment supplier allows a thirty-day trial period. The company expects to pay for the equipment on or before January 31. The equipment is expected to have a 10-year useful life and a $28,000 salvage value.

c.Market research and various meetings with sales staff have produced the following sales projections: January1,000 kayaksFebruary1,500 kayaksMarch750 kayaksApril750 kayakEach Kayak is priced to sell at $950. 50% of the sales will be cash and 50% will be credit. Prepare a sales budget.

d.The company expects to collect 30% of accounts receivable in the month of sale and 70% of accounts receivable in the month following the sale. Prepare a schedule of expected cash receipts.

e.Use the information developed in requirements b and cabove to determine the amount of accounts receivable on the March 31 pro forma balance sheet and the number of sales on the first-quarter pro forma income statement.

f.The company policy is to have finished goods ending inventory of Kayaks in a month equal to 20% of the next months anticipated sales. Prepare a production budget

g. Production of each kayak requires 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next month. The finishing kits can be assembled as they are needed. The company only maintains a small inventory of the finishing kits, 10% of the number needed for production in the next month. The polyethylene powder used in these kayaks costs $1.75 per pound, and the finishing kits cost $190 each. Prepare a direct materials budget.

h.Materialsinventory purchases will all be on account. The company would pay 80% of accounts payable in the month of purchase. It will pay the remaining 20% in the following month. Prepare a schedule of expected cash payments for inventory purchases.

i.Production of a single kayak requires 2 hours of time by more skilled type I employee and 3 hours of finishing time by less skilled type II employees. Type I employees are paid $22per hour, and type II employees are paid $14per hour. Prepare a labor budget.100% of direct labor is paid in the month incurred.

j.Manufacturing overhead is assigned at 150% of labor costs. Depreciation on equipment is included in the assigned overhead (i.e., covered by the 150% rate). Prepare a manufacturing overhead budget.Manufacturing overhead, except depreciation, is paid in themonth incurred.

k.Use the information developed in the requirements above to determine Cost per Kayakand the total amount of cost of goods sold on the first quarter pro form an income statement and the amounts of ending inventory and accounts payable on the March 31pro form a balance sheet.

l.Budgeted monthly selling and administrative expenses are: Variable Cost per unit sold* $45 Fixed Cost Salary Expense 20,000 Rent 4,500 Utilities1,400Miscellaneous1,350 Insurance500 * Variable cost of $45 includes sales commission of $15 per unit sold. Prepare a selling and administrative expense budget.

m.Sales commission and utilities are paid in the month after the month in which they are incurred. All other expenses are paid in the month in which they are incurred. Prepare a schedule of cash payments for selling and administrative expenses.

n.The company is subject to a 20% income tax.

o.Use the information developed in the requirements above to determine the amount of sales commissions payable, utilities payable, and accumulated depreciation on the March 31 pro forma balance sheet and the amount of selling and administrative expense on the first-quarter pro forma income statement.

p.Using a line of credit, the company borrows and repays principal in increments of $1,000 on the last day of the month as needed. It pays interest of 0.5percent(i.e. half of 1%))per month in cash on the last day of the month. Company policy is to maintain an ending cash balance of at least $20,000. Use this and other information developed in the requirements above to prepare a cash budget.

q.Use the information developed above to determine the cash flows from operating, investing, and financing activities on the first quarterpro forma Statement of Cash Flows(SCF), the interest expense on the first quarterpro forma Income Statement(I/S)andthe amount of the ending cash balance and the line of credit liability on the March31pro forma Balance Sheet(B/S).Prepare these documents (SCF, I/S, B/S) in good for

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

978-0133251241, 9780133427516, 133251241, 013342751X, 978-0133255584

Students also viewed these Accounting questions