Question

In: Accounting

After answering A and B, I still keep getting this question with mixed answers, some people...

After answering A and B, I still keep getting this question with mixed answers, some people have interest from borrowing for the quarter and some people don't. Can you help? Thanks

Durianx Inc. distributes a electronic chessboards The following information was gathered to prepare the budget for the third quarter.

Each unit of chessboard is budgeted to sell for an average price of $175. Unit sales are expected to be as follows:

June

9,600 Units

July

9,700 Units

August

10,500 Units

September

11,900 Units

October

12,000 Units

Sales are made for cash and on credit. The following collection pattern is used to estimate monthly cash collections:

Cash sales

30%

Credit sales—month of sale

40%

Credit sales—month after sale

26%

Uncollectible

4%

 Total

100%

The company tries to maintain an inventory of 20% of the following month's sales. The company expects to have 1,940 Units on hand on June 30. Durianx pays an average of $125 per Units.

The company pays for 60% of its purchases in the month of purchase and the remaining 40% in the month after purchase.

The following monthly selling and administrative expenses are planned for t­­he quarter.

July

Aug

Sept

Depreciation

$10,000

$20,000

$20,000

Rent

30,000

30,000

30,000

Advertising

50,000

50,000

50,000

Salaries

350,000

350,000

370,000

Bad debts

67,900

73,500

83,300

On August 1st , the company plans to purchase $500,000 of new office equipment and a delivery truck. Additional depreciation is already accounted for in the above selling and administrative expenses.

Durianx will collect the full $436,800 accounts receivable balance of June 30th in July. Durianx will pay the $481,000 of June Accounts Payable in July.

•Durianx wants to maintain a minimum cash balance of $40,000. An open line of credit at a local bank allows the company to borrow up to $500,000 per quarter in $1,000 increments.

•All borrowing is done at the beginning of the month, and all repayments are made at the end of a month in $1,000 increments. Accrued interest on the loan is paid only when principal is repaid. The interest rate is 12% per year. This means that if the loan is not reimbursed during the quarter then no interest expense is paid during that time.

Durianx's tax rate is 30%.

The June 30 balance sheet is budgeted as follows:

June 30

Cash

$  70,000

Accounts receivable

436,800

Inventory

242,500

Plant & equipment

600,000

Accumulated depreciation

(150,000)

 Total assets

$ 1,199,300

Accounts payable

$ 481,000

Common stock

200,000

Retained earnings

518,300

 Total liabilities and equities

$ 1,199,300

Required (Please answer A AND B)

  1. ( 34 marks ) Prepare all components of Durianx's master budget for the third quarter (Sales Budget, Selling and Administrative Expense Budget, Inventory Purchases Budget, Ending Inventory Budget, Cash Receipts Budget, Cash Payments for Inventory Budget, and Cash Budget)

Prepare a pro-forma income statement for the third quarter.

Prepare a pro-forma balance sheet as of September 30.

  1. ( 8 marks ) Sales manager proposes to decrease the selling price of each unit by $20, to $155. The decrease in the selling price will result in an increase in the number of unit sold by 15%.
    1. Which type of expense do you expect to increase with 15% increase in number of units sold? Which type of expense do you expect to remain unchanged? Explain and give one example for each type of expense.
    2. What will be the net effect on Cash and Net income before income taxes for the quarter ending September 30th? Would you recommend management to implement this proposal? Explain

Solutions

Expert Solution


Related Solutions

I keep getting different answers for this question. Can you explain to me once you've finished...
I keep getting different answers for this question. Can you explain to me once you've finished part a and b how you figured out the accounts receivable? Do we do any repayment for the 3rd quarter and what is the interest? Some people have interest and some don't, what is it really? Durianx Inc. distributes a electronic chessboards The following information was gathered to prepare the budget for the third quarter. • Each unit of chessboard is budgeted to sell...
I do not know why I keep getting this question wrong, I triple checked my work!...
I do not know why I keep getting this question wrong, I triple checked my work! A distribution of values is normal with a mean of 80 and a standard deviation of 18. From this distribution, you are drawing samples of size 23. Find the interval containing the middle-most 40% of sample means: ANSWER HERE Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal...
I working on this program in C++ and I keep getting 20 errors of the same...
I working on this program in C++ and I keep getting 20 errors of the same type again.cpp:36:11: error: use of undeclared identifier 'Polynomial' int main() { // create a list of polinomials vector<Polynomial> polynomials; // welcome message cout << "Welcome to Polynomial Calculator" << endl; int option = 0; while (option != 6) { // display menu displayMenu(); // get user input; cin >> option; if (option == 1) { cout << "Enter a polynomial :" << endl; string...
This question was answered a while ago, but I feel something is still missing for some...
This question was answered a while ago, but I feel something is still missing for some reason, so I will be adding it again for another opinion. Thank you! You are given the data which consists of SAT math scores and University GPA at time of graduation with a four-year degree for fifteen students. Perform a regression analysis on your collected data and submit a written report. The SAT_Math column (variable) is the independent (explanatory) variable. The SAT_Univ column (variable)...
I did most of this problem theres only a part that I keep getting wrong or...
I did most of this problem theres only a part that I keep getting wrong or not getting. I need help figuring out the blank boxes. that says Purchasing and Power and Question 2. Rest is done Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power...
Syntax error in C. I am not familiar with C at all and I keep getting...
Syntax error in C. I am not familiar with C at all and I keep getting this one error "c error expected identifier or '(' before } token" Please show me where I made the error. The error is said to be on the very last line, so the very last bracket #include #include #include #include   int main(int argc, char*_argv[]) {     int input;     if (argc < 2)     {         input = promptUserInput();     }     else     {         input = (int)strtol(_argv[1],NULL, 10);     }     printResult(input);...
I keep getting an error that I cannot figure out with the below VS2019 windows forms...
I keep getting an error that I cannot figure out with the below VS2019 windows forms .net framework windows forms error CS0029 C# Cannot implicitly convert type 'bool' to 'string' It appears to be this that is causing the issue string id; while (id = sr.ReadLine() != null) using System; using System.Collections.Generic; using System.IO; using System.Windows.Forms; namespace Dropbox13 { public partial class SearchForm : Form { private List allStudent = new List(); public SearchForm() { InitializeComponent(); } private void SearchForm_Load(object...
I am making a html game with phaser 3 I keep getting an error at line...
I am making a html game with phaser 3 I keep getting an error at line 53 of this code (expected ;) I have marked the line that needs to be fixed. whenever I add ; my whole code crashes const { Phaser } = require("./phaser.min"); var game; var gameOptions = {     tileSize: 200,     tileSpacing: 20,     boardSize: {     rows: 4,     cols: 4     }    }    window.onload = function() {     var gameConfig = {         width: gameOptions.boardSize.cols * (gameOptions.tileSize +             gameOptions.tileSpacing) + gameOptions.tileSpacing,...
My code works in eclipse, but not in Zybooks. I keep getting this error. Exception in...
My code works in eclipse, but not in Zybooks. I keep getting this error. Exception in thread "main" java.util.NoSuchElementException at java.base/java.util.Scanner.throwFor(Scanner.java:937) at java.base/java.util.Scanner.next(Scanner.java:1478) at Main.main(Main.java:34) Your output Welcome to the food festival! Would you like to place an order? Expected output This test case should produce no output in java import java.util.Scanner; public class Main {    public static void display(String menu[])    {        for(int i=0; i<menu.length; i++)        {            System.out.println (i + " - " + menu[i]);...
I keep getting minor errors I can't figure out and I don't know how to convert...
I keep getting minor errors I can't figure out and I don't know how to convert decimal .10 to percentage 10% either.   With these functions defined now expand the program for a company who gives discounts on items bought in bulk. Create a main function and inside of it ask the user how many different items they are buying. For each item have the user input a price and quantity, validating them with the functions that you wrote. Use your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT